SQL Server monitoring is critical to ensure peak performance and availability of database applications. But this becomes challenging when we use so many tools to capture so much data. It gets confusing to determine what’s a real problem and what we can ignore.
SQL Server includes many tools to help optimize and monitor performance, such as traces, extended events, execution plans, dynamic management views and more. To make the correct changes, you need to know what tool to use, how to collect the right data, how to analyze the data and then make the right adjustments.
MVP Andy Warren will show you how and when to use these tools, so you can make better decisions to ensure proper performance of your database environment. You’ll also see how Quest solutions make this process even simpler.