All geek questions in one place

Sql azure timeout on large SQL tables

im using sql azure to analyze data in large tables (130 million records).

The problem is that when I try to run a query (which locally takes, for example, 12 hours) on azure, I get an error message:

Timed out. The wait period expires before the operation is completed or the server is not responding.

Is there a way to prevent it from happening and run lengthy SQL queries on azure?

+4
source share
2 answers

You cannot complete a query that uses so many resources in a Windows Azure SQL database. This is done in an environment that many users use. Such a request may cause other users to suffer. The last documentation I saw limited the connection to 5 minutes.

However, you can deploy an instance of SQL Server in a Windows Azure virtual machine. There are images in the gallery for this. In this case, you control the entire virtual machine and can use as many resources as you see fit.

+2
source

If you want to use SQL Azure for queries, I would recommend the new Premium reservation function, which is in preview mode. This gives you SQL Azure with dedicated redundancy and eliminates some restrictions such as long queries, throttling, and maximum log size.

http://www.windowsazure.com/en-us/manage/services/sql-databases/sign-up-for-sql-database-premium/

I have large tables with complex queries ... (20 million rows) - provide coverage indexes - READ UNCOMMITED or NOLOCK hints - your friend

+1
source

Source: https://habr.com/ru/post/1497509/

More articles:


All Articles