Specify a Maximum Cost for a Query in SQL Server 7

Specify a Maximum Cost for a Query in SQL Server 7

Ever had a user accidentally create a query that resulted in a Cartesian product of your two largest tables? Of course, a badly written query uses up precious CPU and I/O cycles and therefore slows everyone down. With the advent of SQL Server 7, you can specify a maximum cost for a query. You can do this in two ways. First, set a maximum cost for all queries on your server by setting the configuration option “query governor cost limit” to the maximum number of seconds allowed for a query. (For those of you not familiar with the sp_configure command, this can be done through Enterprise Manager by right clicking on a Server, choosing Properties, clicking the Server setting tab, and choosing the “Use query governor

See also  How College Students Can Shape the Future of Tech Responsibility

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist