Webcast : What You Need to Know About Managing Your SQL Server Performance

When it comes to SQL Server performance, best practices may not always be best. Each SQL Server instance is different. To ensure that your SQL Server is performing optimally, you first need to know what the norm is before you can measure and pinpoint where the performance bottlenecks are. The challenges in analyzing SQL Server performance are twofold: There are overwhelming amounts of metadata, statistics, and performance counters available. At the same time, deciding where one should start the analysis can be quite confusing.

In this session, IT Pro expert Robert Pearl will dive into creating a SQL Server performance roadmap by showing how to create a performance baseline, using the time-tested performance methodology known as waits and queues. He will discuss some of SQL Server’s native DMVs to capture real-time performance data, aggregate it for historical analysis, and report on useful data to highlight performance issues. This session will be helpful for experienced as well as non-expert DBAs who do not have the time to ramp up on the art of performance tuning.