SQL Server Blogs

Voices from the UK SQL Server Community

Rob's SQL Server Blog

... SQL Server thoughts from the field

SQL 2008 Resource Governor

I came across this post in Andrew Fryer's blog, which has a short demo of the SQL Server 2008 resource governor in action. For me, this will be one of the main drivers for moving to SQL Server 2008. Most of the issues I come across with unresponsive SQL Server instances are caused by run-away processes or bad application code consuming all the system resources. The ability to throttle these processes and gaurantee service for other applications using the instance is very compelling and could slash the amount of support calls significantly !

I attended a resource Governor session at Tech Ed IT Forum in Barcelona last year and gave a live demo of the features at my Christmas team meeting, but I can't wait to really get my hands on this feature and give it some thorough testing.

Published Feb 12 2008, 09:29 AM by robcarrol
Filed under: ,


No Comments
Powered by Community Server (Commercial Edition), by Telligent Systems