Presentation Material for Webcast on SQL Server Resource Governor

On 2nd May 2011 (Day 1), I presented webcast on “Managing and Optimizing Resources for SQL Server”. This was a basic session to show capabilities of resource governor feature in SQL 2008. We have been asked about the slides, video and demo by participants. Here is the material I have used. (Video is not yet made available by vendor)

Special thanks to Ron Dunn who gave me permission to use RGExplorer (Nice and clean tool) to show Resource governor demo. With his permission, I am posting source code of the tool. Feel free to modify for your learning purpose. Standard disclaimer applies on tool usage.

Hope you would find it useful.

RGExplorer
SlideDeck
Demo

Day 2 – Full Text Search. Sudarshan
Day 3 – Performance Dash Board – Amit Banerjee

Regards,
Balmukund Lakhani
Technical Lead
SQL Server Support Team