Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2007
    Posts
    8

    Unanswered: limiting the resources

    Hi

    I have a problem on microsoft sql server 2000.
    I need to limit the amount of resources(eg cpu, mem..) a query uses
    Is there a way to do this in SQL server 2000


    Thks in advance

  2. #2
    Join Date
    Feb 2003
    Location
    India
    Posts
    216
    for the server u can limit the max mem usage. u can also limit the max query time for the server as a whole or for a connection. check
    SET QUERY_GOVERNOR_COST_LIMIT at BOL.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •