Using Resource Governor to limit a specific DB

• scribesjeff

  Mr or Mrs. 500

  Points: 580

  More actions

  January 13, 2015 at 5:59 pm

  #294206

  Hello,

  I was looking for a little insight on Resource Governor. I have a request from my manager to limit the resources a certain third party's DB can use on our system. We allow them to keep a DB on our SQL 2012 server so they can run query's to compare data to their server without linking the two machines.

  I was looking into resource manager to perhaps accomplish this task but I'm not real familiar with it. Can anyone tell me if Resource governor can be used to only allow a DB named UserDB1 to use only 1GB or Memory at any one time?

  Or perhaps there is another way aside from Resource governor? If anyone has a suggestion I'd love to hear it.

  Thanks!

• TheSQLGuru

  SSC Guru

  Points: 134017

  More actions

  January 13, 2015 at 7:19 pm

  #1769989

  Start here: http://msdn.microsoft.com/en-us/library/hh510208.aspx

  Best,
  Kevin G. Boles
  SQL Server Consultant
  SQL MVP 2007-2012
  TheSQLGuru on googles mail service

• scribesjeff

  Mr or Mrs. 500

  Points: 580

  More actions

  January 14, 2015 at 4:25 pm

  #1770301

  Thanks Kevin very useful.

  I found this link quite helpful as well.

  https://www.simple-talk.com/sql/learn-sql-server/resource-governor/

  Regards,

  Jeff