SQL Server 2008 introduces two new capabilities: policy-based management and the Resource Governor. Policy-based management allows you to enforce rules for how things should be on one or more servers. The terminology is complex, and the capabilities are immense. The Resource Governor allows you to define workloads and specify the resources, including cpu, memory and i/o bandwidth, a specific workload should have. In this demo-rich presentation, you’ll get an introduction to the capabilities of both of these new features and learn how you can make them work for you. This presentation assumes a solid knowledge of Transact-SQL, a good understanding of SQL Server database engine features, as well as an understanding of the performance requirements of different types of queries.

Sharon Dooley (MCP, former SQL Server MVP) has worked with SQL Server since its first release. Her major areas of specialization are database design and performance tuning, though she also does a lot of administration. She has a consulting practice and teaches and writes courses for Learning Tree International, where she is SQL Server Curriculum Manager. She’s currently hard at work developing Learning Tree’s SQL 2008 Admin course. Ms. Dooley is the author of SQL Server 7.0 Essential Reference (New Riders) and the lead author of Professional SQL Server 6.5 Administration (Wrox). Sharon is an active member of PASS (The Professional Organization for SQL Server) and has presented at numerous conferences. She was named a Microsoft MVP in 2001 and was an MVP for SQL Server until 2004. In her spare time, she enjoys being bossed around by her cats.