I have a desktop application written with c# which uses sql data. I'd planned to run the application on different physical machines at different locations, so I'd intended to use SQL Azure. During development, I realized that Azure sql service is not stable and effective. Application uses approximately 20 datatables which has 100~150 rows maximum. Even with private DSL connection, dataflow is so slow and not reliable. To increase data performance, I thought to go on hybrid mode (with local db on client, sync with Azure) but it did not work efficiently again due Azure sql sync poor performance.

Now I need ideas. What is the best approach to work on hybrid mode? Is it possible to work with Azure Sql Sync which is preview and not fully working? Can I use third party software? Or should I go on local?

Hi,

I am trying to involve someone familiar with this topic to further look at this issue.

Regards,

Mekh.

Hi Sertanpekel,

The speed that you can write to a SQL Database is depending on network latency and how much you can write to the database.

To see if you are impacted by the network latency you can try to create a VM in the same region as the database and push the data from there, or write a stored procedure that writes into a table which would eliminate all network latency for the writes.

If network latency is not the issue, you should check the utilization telemetry to see if you max out the write resources of the database. For Web & Business databases check sys.resource_stats in the master database, for Basic, Standard and Premium use sys.dm_db_resource_stats in the user database. Some more details on how to use these views can be found here: http://azure.microsoft.com/en-us/documentation/articles/sql-database-upgrade-new-service-tiers/

Thanks,

Jan

Hi Sertanpekel,

The speed that you can write to a SQL Database is depending on network latency and how much you can write to the database.

To see if you are impacted by the network latency you can try to create a VM in the same region as the database and push the data from there, or write a stored procedure that writes into a table which would eliminate all network latency for the writes.

If network latency is not the issue, you should check the utilization telemetry to see if you max out the write resources of the database. For Web & Business databases check sys.resource_stats in the master database, for Basic, Standard and Premium use sys.dm_db_resource_stats in the user database. Some more details on how to use these views can be found here: http://azure.microsoft.com/en-us/documentation/articles/sql-database-upgrade-new-service-tiers/

Thanks,

Jan

• Proposed as answer by Jan EngelsbergMicrosoft employee 14 hours 34 minutes ago

Hi Sertanpekel,

The speed that you can write to a SQL Database is depending on network latency and how much you can write to the database.

To see if you are impacted by the network latency you can try to create a VM in the same region as the database and push the data from there, or write a stored procedure that writes into a table which would eliminate all network latency for the writes.

If network latency is not the issue, you should check the utilization telemetry to see if you max out the write resources of the database. For Web & Business databases check sys.resource_stats in the master database, for Basic, Standard and Premium use sys.dm_db_resource_stats in the user database. Some more details on how to use these views can be found here: http://azure.microsoft.com/en-us/documentation/articles/sql-database-upgrade-new-service-tiers/

Thanks,

Jan

• Proposed as answer by Jan EngelsbergMicrosoft employee Saturday, March 07, 2015 4:29 PM

Hi Sertanpekel,

The speed that you can write to a SQL Database is depending on network latency and how much you can write to the database.

To see if you are impacted by the network latency you can try to create a VM in the same region as the database and push the data from there, or write a stored procedure that writes into a table which would eliminate all network latency for the writes.

If network latency is not the issue, you should check the utilization telemetry to see if you max out the write resources of the database. For Web & Business databases check sys.resource_stats in the master database, for Basic, Standard and Premium use sys.dm_db_resource_stats in the user database. Some more details on how to use these views can be found here: http://azure.microsoft.com/en-us/documentation/articles/sql-database-upgrade-new-service-tiers/

Thanks,

Jan

• Proposed as answer by Jan EngelsbergMicrosoft employee Saturday, March 07, 2015 4:29 PM
• Marked as answer by Mekh SubbaMicrosoft contingent staff, Moderator 19 hours 1 minutes ago

Hi Sertanpekel,

The speed that you can write to a SQL Database is depending on network latency and how much you can write to the database.

To see if you are impacted by the network latency you can try to create a VM in the same region as the database and push the data from there, or write a stored procedure that writes into a table which would eliminate all network latency for the writes.

If network latency is not the issue, you should check the utilization telemetry to see if you max out the write resources of the database. For Web & Business databases check sys.resource_stats in the master database, for Basic, Standard and Premium use sys.dm_db_resource_stats in the user database. Some more details on how to use these views can be found here: http://azure.microsoft.com/en-us/documentation/articles/sql-database-upgrade-new-service-tiers/

Thanks,

Jan

• Proposed as answer by Jan EngelsbergMicrosoft employee Saturday, March 07, 2015 4:29 PM
• Marked as answer by Mekh SubbaMicrosoft contingent staff, Moderator Tuesday, March 10, 2015 12:06 PM

Hi Sertanpekel,

The speed that you can write to a SQL Database is depending on network latency and how much you can write to the database.

To see if you are impacted by the network latency you can try to create a VM in the same region as the database and push the data from there, or write a stored procedure that writes into a table which would eliminate all network latency for the writes.

If network latency is not the issue, you should check the utilization telemetry to see if you max out the write resources of the database. For Web & Business databases check sys.resource_stats in the master database, for Basic, Standard and Premium use sys.dm_db_resource_stats in the user database. Some more details on how to use these views can be found here: http://azure.microsoft.com/en-us/documentation/articles/sql-database-upgrade-new-service-tiers/

Thanks,

Jan

• Proposed as answer by Jan EngelsbergMicrosoft employee Saturday, March 07, 2015 4:29 PM
• Marked as answer by Mekh SubbaMicrosoft contingent staff, Moderator Tuesday, March 10, 2015 12:06 PM

Hi,

Could you please provide more detail about the performance when using SQL Data Sync? The performance of sync data depends on several factors, e.g. the performance of read/write data with your SQL database, network latency, table schema, etc. Please provide the more detail info (SQL Azure database tier, data size, data row count, etc.) for us to figure out the bottleneck.

Regards,
Bowen

Hi,

Could you please provide more detail about the performance when using SQL Data Sync? The performance of sync data depends on several factors, e.g. the performance of read/write data with your SQL database, network latency, table schema, etc. Please provide the more detail info (SQL Azure database tier, data size, data row count, etc.) for us to figure out the bottleneck.

Regards,
Bowen

• Proposed as answer by Bowen Wan 21 hours 45 minutes ago

Hi,

Could you please provide more detail about the performance when using SQL Data Sync? The performance of sync data depends on several factors, e.g. the performance of read/write data with your SQL database, network latency, table schema, etc. Please provide the more detail info (SQL Azure database tier, data size, data row count, etc.) for us to figure out the bottleneck.

Regards,
Bowen

• Proposed as answer by Bowen Wan Saturday, March 07, 2015 9:18 AM

Hi,

Could you please provide more detail about the performance when using SQL Data Sync? The performance of sync data depends on several factors, e.g. the performance of read/write data with your SQL database, network latency, table schema, etc. Please provide the more detail info (SQL Azure database tier, data size, data row count, etc.) for us to figure out the bottleneck.

Regards,
Bowen

• Proposed as answer by Bowen Wan Saturday, March 07, 2015 9:18 AM