CODEWITHSUNDEEP
sqlsql-server-2005resource-governor
Beans
Beans

Reputation: 329

SQL Server Resource Governor on Single Database

I have a database for a piece of proprietary software that resides on a SQL Server 2005 instance shared with some databases for C# apps I developed. I'm having an issue with some of the proprietary software's stored procedures eating up resources. Is there a way for me to limit the CPU usage of a particular database? I've advocated moving the DBs to a different server / instance, but I need a solution that can hold me off until then.

Upvotes: 1

Views: 657

Answers (1)

Amir Keshavarz
Amir Keshavarz

Reputation: 3108

You can use resource governor and have a function on it which guide system to a workload with database name , and then limit cpu and memory.

Upvotes: 2

Related Questions