Anything But: Troubleshooting When it’s Not SQL Server

Ben DeBow

Here we go again: the SQL Server is slow but where is the problem? Is there a large blocking chain or a high number of deadlock events? Maybe it is a slow query using a large number of resources? Does the query have a non-optimal execution plan? Many times as a DBA, we ask these same questions and answer NO to all of them because the performance issue is outside of SQL Server. In this session, we will focus on troubleshooting all of the typical issues that are not SQL Server-related but impact SQL Server. We will explore troubleshooting virtualization, storage, memory, CPU, OS, and networking issues.