SpeakerRate

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, but there are also third party tools that take a lot of guess work and manual labor out of this process. This session will cover the native SQL Server tools used for generating the baseline measurement and Red Gate's SQL Monitor. 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.