SQL Server performance is slow. Users are complaining. Your boss wants to know what's going on and what you can do to improve SQL Server performance. Where do you start? Which SQL Server query should you investigate first? What can you tune? More importantly, what can you tune without touching code?
In this on-demand session, we'll look at the entire SQL Server holistically, from the "hardware" allocated to the machine down to individual SQL Server query plans. We'll cover what tools are provided out of the box, from Performance Monitor to Query Store, that you can use to spot the bottlenecks on your system.
Then we'll talk about what you can do to improve SQL Server performance. Will throwing hardware at the problem hide it until you can put in a real fix? Or do you need to roll up your sleeves and rewrite some common, poorly performing queries? What is the tradeoff? Armed with this knowledge, not only will you be able to identify what's broken, but you'll also be able to give your organization options on how to fix it. By the end of this on-demand webcast, you’ll be able to boost SQL Server query speed and make your SQL Servers run at peak performance.