Presenter: Grant Fritchey – SQL Server MVP
Topic: Gathering and Interpreting Server Metrics
Before you can start tuning SQL queries, it’s vital that you know how your server itself is behaving. You need to know what the memory, IO and CPU on the machine look like while the system is at rest and under load. You need to establish this baseline in order to better interpret the results of your later query tuning efforts.
There are a number of inherent methods built into SQL Server and the Windows operating system that can supply you with this vital information. There are even third party tools that can take a lot of guess work and manual labor out of the process of establishing these vital measures. This session will cover all the tools necessary to generate a baseline measurement for performance of your SQL Server system. The session is a small part of and serves as an introduction to the one day pre-conference seminar on query performance tuning being offered at SQLRally in May.
Grant Fritchey has twenty years experience in IT. That time was spent in technical support, development and database administration. For the last seven years he has been working at a major insurance company as a DBA. He writes articles for publication at SQL Server Central, Simple-Talk, PASS Book Reviews and SQL Server Standard. He also published two books, ”Dissecting SQL Server Execution Plans” and “SQL Server 2008 Query Performance Tuning Distilled.” He is one of the founding officers of the this Users Group and currently serving as the president. In April 2009 he was awarded as a Microsoft SQL Server MVP. You can also find him tweeting as @GFritchey and blogging at Home of the Scary DBA.