Tech Brief

Performance Management Solutions for SQL Server

This technical brief discusses the value that can be realized by using Dell's SQL Server Performance Management products: Foglight Performance Analysis for SQL Server; and, Spotlight on SQL Server Enterprise.

This document also covers in detail the use of this solution set for solving specific (and common) use cases including:

  • CPU bottlenecks
  • I/O bottlenecks
  • Memory pressure issues
  • TempDB troubleshooting