Webcast : Performance Tuning Your SQL Server Database and Maybe Even Your Data

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 :

Aaron Nelson

Aaron Nelson is a Microsoft MVP for SQL Server (Data Platform) and leads the PowerShell Virtual Chapters of PASS, and volunteers for the local PASS Chapter AtlantaMDF, and helps organize SQL Saturday events in Atlanta.

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