Pinal Dave as already written an excellent article on how to configure and use Resource Governor. Please refer that in the below link:
https://blog.sqlauthority.com/2012/06/04/sql-server-simple-example-to-configure-resource-governor-introduction-to-resource-governor/
Other useful resources:
https://www.red-gate.com/simple-talk/sql/learn-sql-server/resource-governor/
https://www.sqlshack.com/sql-server-2014-resource-governor/
http://www.sqlpassion.at/archive/2014/01/14/how-to-throttle-your-storage-with-resource-governor-in-sql-server-2014/
Enable this feature at your own risk. Go through the below link to know the problems with it.
https://www.brentozar.com/blitz/resource-governor-enabled/
No comments:
Post a Comment