Session 1: Where is My Performance Issue?

Presented by: Ben DeBow

Running Time: 60min

When someone comes to you and says their application or database is slow, they are assuming that SQL Server must obviously be the cause. Most DBAs even think that way. However, what seems to manifest itself as a problem in SQL Server (such as a slow query) could really be due to other external factors such as a suboptimal configuration of the underlying server either at the operating system or hardware levels. Improving performance involves much more than tuning queries and indexes – you need to know about Windows, disk, network, and other things to determine where your bottlenecks are and how to overcome them. This session will discuss some of the most common methods for troubleshooting SQL Server performance issues and provide practical advice for solving many non-SQL Server related causes of slow performance.