Windows – How to reserve system resources to specific SQL Server 2005 databases

sql serversql-server-2005windowswindows-server-2003

Is it possible to specify a min/max amount of system resources (Disk IO, Memory, CPU cycles/s) available to each database instance inside a SQL Server 2005 server?

This would be the analogue of QoS settings for SQL Servers.

Best Answer

No. They all use the sqlservr.exe process which is the SQL Server Instance.

If you need to manage database level resources, then you need a separate instance

Generally, I've found that multiple databases on the same instance usually balances out. Each database has it's own usage pattern, load pattern, number of users etc, and SQL Server manages buffer pool, plan caches, memory etc based on this load very well.

If you have a database with some poor code or hogs resources, then I'd suggest it's own hardware or at least instance.

Related Topic