Geek asks and answers

How to measure the cost of SQL queries to meet the requirements of SQL Governor?

On a shared hosting provider, I get an error:

The request was canceled because the estimated cost of this request (1660) exceeds the set threshold of 1500. Contact your system administrator.

I understand that this is due to the fact that SQL Governor is enabled in the instance of SQL Server 2008 used, and therefore I need to reduce the cost of my query.

I would like to reproduce this condition on my dev machine. However, the resource controller is only available in the corporate version of MSSQL2008 (which I do not have), so I can not enable it locally.

Is it possible to localize a query? What are the units of this limit (1500)?

EDIT To be clear, I already have MSSQL on my machine, but the version does not support SQL Governor (for this you need the Enterprise version.)

+3
source share
1 answer

Take a copy of SQL Developer Edition. It is dirty and has all the features of a full-blown enterprise. With our volume license, we got a $ 30 license.

If you do not want to buy it, you can download a 60-day (or longer) trial version and at least use it long enough to eliminate your situation.

http://www.microsoft.com/sqlserver/2008/en/us/trial-software.aspx

, , . .

: - ( ). , , max , -go.

+2

More articles:


All Articles