Webcast : Exploring the Plan Cache to Optimize SQL Server Performance

Performance tuning for SQL Server can be a tricky business. When deciding what to change to fix the problem you may face the issue of “Fixing one problem isn’t going to cause more issues with something else, is it?” or “SQL Server keeps adding features to tune itself, so we don’t need to worry about this anymore, right?”. Well both of these may be true, there is still work to be done and choosing the correct path can make all the difference.

In this session, we will go over key performance issues affecting both OLTP & OLAP workloads, show how to identify them, and options for correcting them. And while SQL Server has made great strides in improving performance automatically, some fixes are a little less obvious, some fixes require talking to your end users, and sometimes, it’s the data itself that needs to be performance tuned.

Topics :

Products :

Andy Warren

Andy Warren is a SQL Server consultant based in Orlando. Andy was a founding principal of SQLServerCentral.com, is the former President of the Orlando SQL Server Users Group, and one of the founders of SQLSaturday. He has been an MVP since 2009 and has written and presented extensively SQL Server. Andy blogs at www.sqlandy.com, is on LinkedIn at www.linkedin.com/in/sqlandy, and is occasionally on Twitter as @SQLAndy.

Try SQL Diagnostic Manager for SQL Server FREE for 14 days


SQL Diagnostic Manager Repository dashboard

24X7 SQL performance monitoring, alerting and diagnostics

  • Monitor performance for physical, virtual, and cloud environments.
  • Monitor queries and query plans to see the causes of blocks and deadlocks.
  • Monitor application transactions with SQL Workload Analysis add-on.
  • View expert recommendations from SQL Doctor to optimize performance.
  • Alert predictively with settings to avoid false alerts.
  • View summary of top issues and alerts with the web console add-on.

Start for Free