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.