Page History
...
SQL Workload Analysis provides deep visibility past the database and into the EMC storage array, including the ability to detect contention on physical disks or virtual pools. In order to enable this extended visibility, some EMC software needs to be installed on the SQL Workload Analysis server as well as the database hosts. Please consult the following document for the full details of how to extend SQL Workload Analysis' visibility into EMC Storage: SQL Workload Analysis – Installing and Verifying EMC Solution Enabler.
Why do certain statements show zero execution counts?
IDERA SQL Workload Analysis computes the top SQL statements in terms of time spent in the database from one source of such data in the system tables of SQL Server and correlates this with the execution count of that statement from another source (i.e another set of system tables in the SQL Server). Because of sampling rates, sampling errors, and the transient nature of the latter source, the correlation is sometimes not possible for certain statements with very few executions in any given time frame.