Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

Home > Success Center > Database Performance Analyzer (DPA) > Missing SQL statistics when monitoring SQL Server 2005

Missing SQL statistics when monitoring SQL Server 2005

Table of contents
No headers

 

This article applies to DPA 8.0 and later.

 

DPA collects SQL execution statistics when monitoring SQL Server 2005 and later. If certain SQL statements are missing SQL execution statistics, it may be because:

 

SQL statistics collection was turned off for the monitored database instance.

  1. Click Options > Administration > Advanced Options > DB Instance Options.
  2. Click the Support Options check box.
  3. Select the database instance.
  4. Click the ENABLE_SQLSTATS option. If set to False, change to True.

 

The SQL buffer cache on the monitored database is too small or too many distinct SQL statements are executed on the monitored database. SQL statistics are queried every 10 minutes and compared to the previously queried values. If the same SQL statement cannot be found in the buffer cache after 10 minutes, no SQL statistics can be calculated for that SQL statement.

 

The SQL statement is contained within a stored procedure that has been compiled with the RECOMPILE option, or the SQL statement uses the RECOMPILE query hint. This causes SQL Server to recompile the stored procedure or statement before every execution and to not store the SQL plan in the buffer cache. If the SQL plan for the statement is not stored in the buffer cache, SQL Server does not track SQL statistics for that statement.

Last modified
15:18, 4 Jan 2016

Tags

Classifications

Public