Foglight for SQL Server (Cartridge) 5.7.5.30 - User Guide

Foglight for SQL Server Collections and Metrics

NOTE: All of the information collected according to the definitions described in this section is displayed on Foglight for SQL Server. For details, see the Foglight for SQL Server User Guide.

NOTE: Several collections contain metrics whose name ends with Rate (for example: Physical Writes Rate and Physical Disks Rate). Such metrics, which are not documented in this guide, are used for plotting the original metric (usually called by the same name without the “Rate” suffix) on a graph for the selected time range.

Column	Description
Collection Name	The collection name, as retrieved by the agent.
Display Name	The collection name, as displayed in the application’s sections to which the collection retrieves information.
Description	The name of the collection. This list is sorted in alphabetical order.
Offline Frequency	Allows defining the collection interval, in seconds, in low frequency mode (for example: 300). Low frequency mode refers to the frequency at which the agent collects data when no user is currently connected to the monitored instance.
Online Frequency	Allows defining the collection interval, in seconds, in high frequency mode (for example: 60). High frequency mode refers to the frequency at which the agent collects data when none of the currently logged-on users are in focus on a screen, which displays any of the metrics sampled by this collection.
Real-time Frequency	Allows defining the collection interval, in seconds, in real-time frequency mode (for example: 20). Fast frequency mode refers to the frequency at which the agent collects data when one or more of the currently logged-on users are in focus on a screen, which displays any of the metrics sampled by this collection.

Frequency Mode	Collection Interval (In Seconds)
Real-time	20
Online	60
Offline	300

Display Name	Description
Forwarded Records	The total number of records that were retrieved by SQL Server during the specified time range. When a row in a table that does not have a clustering index is updated, and if the modified row no longer fits on the old page, SQL Server moves the row to a new page and leaves a forwarding pointer in the old page. As a result, the non-clustered indexes do not have to be modified to reflect the new row location, but will cause subsequent retrieval of this row, by means of non-clustered indexes to require an extra I/O. A high Forwarded Records rate can indicate a need for reorganizing tables (unloading/reloading) or defining clustered indexes.
Free Space Scans	The number of scans initiated to search for free space to insert a new record.
Full Scans	The number of unrestricted full scans per second (either base-table or full-index scans).
Index Searches	The number of index searches per second. These searches are used to start a range scan, reposition a range scan, revalidate a scan point, fetch a single index record, and search down the index to locate where to insert a new row.
Page Allocations	The total number of pages that were allocated to tables or indexes during the specified time range. This metric indicates how fast tables are expanding.
Page Allocations Rate	The rate per second at which pages are allocated to tables or indexes.
Page Deallocations	The total number of pages that were deallocated from tables or indexes during the specified time range. This metric indicates how fast tables are shrinking.
Page Deallocations Rate	The rate per second at which pages are deallocated from tables or indexes.
Page Splits	The number of page splits that took place within the defined time range. Page splitting occurs when an index or data page becomes full and then is split between the existing page and a newly allocated page. Excess page splitting can lead to I/O performance issues. High and increasing values may indicate that either the indexes needs to be rebuilt and / or the indexes fill factor should be increased.
Page Splits vs Page Writes	The ratio of page splits per writes. When an index or data page becomes full during an insert operation, data is split between the current page and a newly allocated page. Excessive page splitting can result in excessive disk I/O, thereby contributing to performance degradation. Higher values of this metric indicate that page splitting affects the monitored application's I/O performance. To resolve this issue, check your database file configuration, the selected index fill factor, and the rate at which your transactions are committed.
Probe Scans	The number of probe scans. A probe scan is used to directly look up rows in an index or base table.
Range Scans	The number of qualified range scans through indexes.
Skipped Ghosted Records	The total number of ghosted records that were encountered by SQL Server during scans over the specified time range. When a record is deleted from a table, SQL Server improves concurrency by not physically removing the row from index leaf levels, but marking it instead as deleted (ghosted). At some later point, a housekeeping process asynchronously removes these rows from the leaf level. Until the records are removed, SQL Server must skip the ghosted records during leaf-level scans.
Skipped Ghosted Records Rate	The rate per second at which SQL Server encounters ghosted records during scans.
Table Lock Escalations	The number of times a lock on a table has been escalated during the specified time range. Lock escalation is not necessarily a problem by itself; however, it can cause concurrency issues and lock conflicts, and can be a major contributor to blocking problems and deadlocks.

Frequency Mode	Collection Interval (In Seconds)
Real-time	60
Online	300
Offline	3600

Display Name	Description
Alert Name	The name of the alert that was raised.
Alert Type	The type of alert.
Database	The name of the database where the alert was raised.
Definition	A brief description of the specified alert.
Enabled	The status of the alert.
Last Occurred	The previous time the alert was raised.
Occurrences	The number of the alert’s occurrences.

Frequency Mode	Collection Interval (In Seconds)
Real-time	60
Online	300
Offline	3600

Display Name	Description
Category	The SQL Agent job category assigned to this job.
Current Server Time	The Server time at the time the query ran.
Current Status	The current status of the job (Running or Inactive).
Current Step Number	Displays the current step number if the job is currently running.
Description	A brief description of the job.
Is Enabled	Determines whether the job can be run.
Job Name	The name of the job.
Job State	The current state of the job.
Jobs Failed Threshold	A flag indicating that a job has failed.
Jobs Retry Threshold	A flag indicating that a job retry has occurred.
Last Run Duration	Indicates how long the last run took (displayed in the d hh:mm:ss format).
Last Run Finish Time	The time the job finished.
Last Run Message	The last message associated with that step in the job.
Last Run Outcome	The result of the last run (Success or Fail).
Last Run Outcome Threshold	A flag indicating that the last run’s outcome is a job retry.
Last Run Time	The date/time on which the job last ran.
Long Running Job Threshold	A flag indicating that a long running job has occurred.
Next Run Time	The date and time of the next scheduled run.
Raise Alarm	Indicates whether the job raised an alarm the last time it ran.
Short Job Name	The short name of the job (in cases where the job name is too long to be displayed in full).

Frequency Mode	Collection Interval (In Seconds)
Real-time	60
Online	60
Offline	60

Display Name	Description
Blocked	The total number of all blocked sessions.
Blocked by	The session that is currently blocking the selected session.
Blocked Time	Total wait time spent by all blocked sessions.
Command	The current or previous command executed.
CPU	The total amount of CPU consumed so far by the session. This metric can be useful when deciding which sessions to kill.
Database	The name of the database.
Host Name	The name of the client computer.
Lock Type	The type of the resource that is currently locked (Database, Table, Page, Row, Extent, and so on).
Locking	The unique session number for the session that either owns or requests the lock.
Login Time	The time that the session was created.
Mode	The kind of lock being applied to the resource (Shared, Exclusive, Update, IntentShared, IntenExclusive and so on).
OS User	Windows user name for a session that uses Windows Authentication.
Physical IO	The total amount of I/O operations carried out so far by the session. This metric can be useful when deciding which sessions to kill.
Program	The name of the application that the user is currently running (for example, Microsoft Access).
Request Status	• The status of the lock; can have one of the following values: • WAIT = Wait for another resource. • CNVT = Converted to another resource. • GRANT = the lock has granted.
Resource	The resource that is in conflict. This metric often identifies a database and table. The data in the Resource column is reported directly from SQL Server and, for performance reasons, is not resolved to actual resource names during normal data collection.
SQL Text	Displays the SQL text of the session that is blocked and/or blocking
SQL User	The SQL Server user login name for this session
Status	The status of the session (Blocked, Blocking or both). For sessions at the head of the blocking chain (those that are not blocked), this metric also indicates if the session is Runnable or Sleeping.
Type	The type of the lock request that is waiting (for example: Database, Table, Page, Row, Key, and Extent)
Wait Time	Indicates how long this session has been waiting for the lock (measured in seconds). This shows 0 if the session is not waiting.

Display Name	Description
Blocked By SPID	Indicates which SPID (if any) holds locks on a resource on which this session is waiting.
Command	The current or previous command executed. This information can be useful when deciding which sessions to kill.
CPU	The total amount of CPU consumed by the session so far. This information can be useful when deciding which sessions to kill.
Database	The name of the database.
Host Name	The name of the Client computer.
OS User	Windows user name for a session that uses Windows Authentication.
Physical I/O	The total amount of I/O consumed by the session so far. This information can be useful when deciding which sessions to kill.
Program	The application program that the user is using (for example, Microsoft Access).
Resource	The resource that is in conflict. This value often identifies a database and table. The Resource data is reported directly from SQL Server.
SPID	The session unique identifier (Session Process ID).
SQL Text	Displays the SQL belonging to the session that is blocked and/or blocking.
SQL User	The SQL Server user login name for this session.
Status	The status of the session (Blocked, Blocking or both). For sessions at the head of the blocking chain (those that are not blocked), this also indicates if the session is Runnable or Sleeping.
Type	The type of the lock request that is waiting (Database, Table, Page, Row, Key, Extent and so on).
Wait Time	Indicates how long this session has been waiting for the lock (measured in seconds). If the value displayed is 0, the session is not waiting.

Frequency Mode	Collection Interval (In Seconds)
Real-time	60

Display Name	Description
% Object Dirty	Percentage of object modified pages.
% Of Cache	The percentage of cache used by the object.
% Of Object	The percentage of object in the cache.
Cached MB	The amount of cache used by the object.
Database	The name of the database where the object resides.
Dirty Size	Size of object modified pages in megabytes.
File Group	The file group where the object resides.
Index	The index name (if the object is an index). If this column is left empty, the object is a heap.
Index ID	The index identifier (if the object is an index). This metric can have one of the following values: • 0 — Heap • 1 — Clustered index • > 1 — Non-clustered index
Object Size	Object allocation size in megabytes.
Owner	The user name of the object's owner.
Row ID	The row ID provides a unique identification of each row.
Table	The table name (if the object is a table).
Unused Allocated Cache	The amount of allocated cache that is not used by the object.

Frequency Mode	Collection Interval (In Seconds)
Real-time	20
Online	60
Offline	300

Display Name	Description
Buffer Cache Free Size	The total number of free pages on all free lists. This value is calculated as follows: <free pages> * 8K / 1024. When SQL Server needs a free memory page (for example, when reading a database page from disk into the buffer cache), and if no free pages are immediately available, the connection needing the free page will have to wait while SQL Server makes buffers available. This will result in slower performance. In the worst case, the connection will have to wait while SQL Server writes a modified page out to disk in order to make a free buffer.
Buffer Cache Hit Rate	The total number of cache hits.
Buffer Cache Hit Ratio	The ratio of physical reads to logical reads. It indicates the percentage of database page I/O requests that were satisfied from the Buffer Cache and therefore did not have to perform disk reads. This ratio measures how efficiently SQL Server is using the memory allocated to its buffer cache.
Buffer Cache Reads	The total number of cache lookups over the last few thousand page accesses.
Buffer Cache Size	The amount of memory currently allocated to the buffer cache, including database, free, and stolen pages. This size is calculated as follows: <free pages> * 8K / 1024. The Buffer Cache is an in-memory copy of recently used database pages.
Checkpoint Pages	The number of pages flushed by checkpoint or other operations that require all dirty pages to be flushed.
Database Pages	The number of pages that constitute the SQL data cache. A large change in this value indicates the database is swapping cache values from the cache. This database pages value is calculated as follows: <pages> * 8KB / 1024. SQL Server keeps a copy of its most recently used database pages in the buffer cache. When a connection needs to reference a database page, SQL Server performs a Logical I/O operation by checking the buffer cache to see if the requested page is already in memory. If the page is found in the buffer cache, a logical I/O read will be carried out; otherwise, the page is read from disk, using a Physical I/O operation.
Free Pages	The total number of free pages on all free lists. This value is calculated as follows: <free pages> * 8K / 1024. The Lazy Writer Process periodically scans all SQL Server caches, and maintains a list of such “free” pages. When SQL Server needs a free memory page (for example, when reading a database page from disk into the buffer cache), and no free pages are immediately available, the connection needing the free page must wait while SQL Server makes buffers available. This results in slower performance. In the worst case, the connection will have to wait while SQL Server writes a modified page out to disk in order to make a free buffer.
Lazy Writes	The number of buffer pages that have been modified in the buffer cache, which the Lazy Writer process is flushing to disk. A high value of lazy writes may indicate that SQL Server is running out of available space in the buffer pool cache.
Logical Page Reads	The number of logical database page reads issued. Under optimal work conditions, the SQL Server connections use logical page reads, that is: reference pages from the buffer cache. However, if the required page is not yet in the cache, it is read from disk using physical I/O operations. A high value of the logical page reads indicates that SQL Server efficiently uses the memory allocated to its buffer cache. A high value of physical page reads, on the other hand, indicates that SQL Server is finding fewer pages already in memory, and therefore has to perform more disk reads.
Page Life Expectancy	The value of page life expectancy, that is: the length of time in seconds that a database page will stay in the buffer cache without being accessed, before it is flushed out. Microsoft recommends keeping this value greater than five minutes (300 seconds). Values smaller than 300 indicate that pages are being flushed out of the cache within a small period of time. The resulting lack of pages in the buffer cache requires SQL Server to carry out more disk reads, thereby degrading its performance.
Physical Page Reads	The number of physical database page reads issued. Physical page reads are used when a connection requests a page that is not already in the buffer cache.
Physical Page Writes	The number of physical database page writes issued. Normally, SQL users do not have to wait for database write operations to complete. Most modifications to database pages are made in the buffer cache.
Read Ahead Pages	The number of pages being read from disk before they are requested, using the Read Ahead process. Read ahead is the process by which SQL Server anticipates which pages a session will require, and reads them into the Buffer Cache before they are requested by the user connection. This process is used when SQL Server determines that a session is accessing table or index pages in a sequential manner. If the sequential processing does continue, these pages will be in the cache memory when required, thereby avoiding the need to wait for an I/O operation. Read Ahead can improve queries’ performance when accessing a new table or an existing table with a new filter. However, a high level of Read Ahead activity may indicate poorly coded SQL statements or inadequate indexes.
Read Ahead Pages Rate	The rate per second at which pages were read from disk before being requested, using the Read Ahead process.
Reserved Pages	The number of buffer pool reserved pages. The reserved pages value is calculated as follows: <pages> * 8KB / 1024.
SQL Server Physical I/O Operations	Total number of pages read or written to disk. Even though some of these operations may be satisfied by the file system cache, they usually require physical disk access.
Stolen Pages	Pages “stolen” from the buffer pool to be used for miscellaneous server purposes, when Windows requires memory for another application. A large number of stolen pages may be normal for a short period (for example: if the system backup begins after a large database batch run completes). However, a constantly high value of this metric may indicate overall system memory shortage.
Target Pages	The ideal number of pages in the buffer pool. The target pages value is calculated by <pages> * 8KB / 1024.

Frequency Mode	Collection Interval (In Seconds)
Real-time	20
Online	60
Offline	300

Display Name	Description
Database	The database name
Is Hidden	Indicates whether there is a hidden CLR assemble within the selected database.
Is External	Indicates whether there is an external CLR assemble within the selected database.
Is Unsafe	Indicates whether there is an unsafe CLR assemble within the selected database.

Frequency Mode	Collection Interval (In Seconds)
Real-time	900
Online	900
Offline	14400

Display Name	Description
ID	The unique identifier for the specified resource in the cluster.
Parent ID	The parent ID of the node’s vertical level.
Type	The type of resource (Resource group).
Name	The resource name.
Status	The status of the cluster resource.
Comment	A brief description of the specified cluster resource (if available).
Other Data	The group to which the resource belongs.
Icon Flag	A flag indicating whether there is an error.
Take Offline Cmd	A flag indicating the existence of a command that runs when the resource goes offline.
Bring Online Cmd	A flag indicating the existence of a command that runs when the resource goes online.
Move Group Cmd	A flag indicating the existence of a command that runs when the resource is moved to another group.
Stop MSCS Cmd	A flag indicating the existence of a command that runs when the resource is stopped.
Start MSCS Cmd	A flag indicating the existence of a command that runs when the resource is started.
Running On Preferred Server	A flag indicating whether the node is running on a server that appears on the preferences list.
Controls The Current SQL Server	A flag indicating whether the node is currently controlling the SQL Server.
Running On Server	Indicates the host (server) on which the selected node is running.
Non Active Node Available	Indicates which non-active SQL Server nodes are currently not running.
Can Accept Move	A flag indicating whether the resource can accept being moved to another group.

Frequency Mode	Collection Interval (In Seconds)
Real-time	3600
Online	3600
Offline	86400

Display Name	Description
Config Value	The value to which the configuration option is set. This value may not be implemented immediately upon creation. Usually, restarting SQL Server is necessary before any change takes effect.
Description	A description of the specified configuration option.
Last Change	The date when the value was last changed.
Last Run Value	The most recent value, set during the last modification.
Max	The maximum permitted value for the configuration option.
Min	The minimum permitted value for the configuration option.
Modifiable	Indicates when changes to the option take effect. The following options are possible: • Immediate: changes to these options take effect immediately. • Restart: changes to these options take effect after SQL Server is stopped and restarted. • Never: these options cannot be modified.
Name	The name of the specified configuration option.
Run Value	The value currently used by the configuration option.

Display Name	Description
All Density	Density is the term used by SQL Server to represent the selectivity of the index columns. The more selective an index is, the more useful it is in searches. Calculated as 1 / distinct values for all values in the first key column of the statistics object, excluding the histogram boundary values. This Density value is not used by the query optimizer, and is displayed for backward compatibility with versions prior to SQL Server 2008.
Avg Key Length	Average number of bytes per value for all of the key columns in the statistics object.
Columns	The names of the columns in the index.

Display Name	Description
Density	Density is the term used by SQL Server to represent the selectivity of the index columns. The more selective an index is, the more useful it is in searches. Calculated as 1 / distinct values for all values in the first key column of the statistics object, excluding the histogram boundary values. This Density value is not used by the query optimizer, and is displayed for backward compatibility with versions prior to SQL Server 2008.
Last Updated	The time and date when the statistics were last updated.
Rows	The number of rows in the index.
Rows Sampled	Number of rows sampled for statistics information.
Steps	The number of distribution steps.

Display Name	Description
Database	The database ID.
Index	The index ID.
Index Property	The property name of each element of the index.
Owner	The schema owner.
Property Value	The value of each element of the index.
Table	The table ID.

Display Name	Description
Avg Range Rows	Average number of rows that corresponds to the last high range and the current one inclusive (Range Rows / Distinct Range Rows for Distinct Range Rows > 0).
Distinct Range Rows	Number of distinct rows that correspond to the last high range and the current one inclusive.
Equal Rows	Number of rows that correspond to the current high range.
Range High Key	The upper bound value of a histogram step.
Range Rows	Number of rows that corresponds to the last high range and the current one inclusive.

Display Name	Description
DB Name	The name of the specified database.
FG Name	The name of the File Group where the index resides.
Free MB	The free size left for the index to grow, in megabytes.
Index Id	Unique identifier of the index.
Index MB	The size of the index at the time of its last statistics update, measured in megabytes.
Index Name	The name of the index.
Num Keys	The number of keys held by the index.
Orig Fill Factor	Represents the size the index occupies as a percentage of the total index page (8 KB).
Owner Name	The owner of the index.
Qualified Name	The full qualified name of the database object.
Row Mod Ctr	The number of row modifications made since statistics were last updated for this index.
Rows	The number of rows in the table.
Table Name	The table with which the index is associated.
Type	The index type.
Used MB	The actual size occupied by the index, in megabytes.

Frequency Mode	Collection Interval (In Seconds)
Real-time	900
Online	900
Offline	3600

Display Name	Description
% Log Used	The percentage of used space within the file space allocated to the transaction log of each currently used database. Log space can be freed up by backing up the log, or truncating it, using the truncate option (backup log <dbname> with truncate_only). All log records that exist after the oldest open transaction cannot be freed.
Average Active Transactions	Average number of active transactions during the specified time range.
Average Log Flush Wait Time	Average amount of time (in milliseconds) spent waiting for log flushes in each database. A high log flush wait time can result from a slow or overworked disk subsystem. If a database has a consistently high value of log flush wait time, with no changes, run the SQL command CHECKPOINT on that database to force another log flush and check the value again.
Average Transactions	Average transactions for each database.
Average Transactions Rate	The average rate per second of transactions executed for each database.
Backup Throughput MB	Data transition size (in MB) of backup or restore commands that are reading or writing to the database. While backups are essential, other users will probably experience performance degradation while these operations run.
Backup Throughput Rate	The rate (measured in megabytes per second) at which backup or restore commands are reading or writing to the database. While backups are essential, other users may experience performance degradation while these operations run.
Bulk Copy Throughput	Data transition size (in MB) of data being loaded into the database using BCP (Bulk Copy Program) or BULK INSERT. While BCP and BULK INSERT are the fastest way of getting data into SQL Server, other users will in most probability experience performance degradation while these operations run.
Bulk Copy Throughput Rate	The rate (measured in megabytes per second) at which data is being loaded into the database using BCP (Bulk Copy Program) or BULK INSERT. Despite the top speed at which BCP and BULK INSERT can import data into SQL Server, system I/O performance may degrade while BCP operations are underway.
Database ID	The database ID.
Database Name	The name of the database.
DBCC Scans	The size (in MB) of data transition resulting from data logical read scans carried out by Database Console Commands (DBCC).
Log Cache	The total number of reads that were satisfied from the log cache, thereby avoiding physical log I/O operations.
Log Cache Hit Rate	The rate per second of log cache reads, namely: reads that were satisfied from the log cache, thereby avoiding physical log I/O operations.
Log Cache Hit Ratio	The percentage of reads that were satisfied from the log, thereby avoiding physical log I/O operations.
Log File Size	The amount of disk space that the log files are using.
Log Flush Wait Time	The amount of time spent waiting for log flushes in each database. The log flush operation, which is necessary to guarantee that transactions can be recovered in the event of a system failure, is most commonly caused when a user is issuing a commit transaction. A high log flush wait time can result from a slow or overworked disk subsystem. If a database has a consistently high value of log flush wait time, run the SQL command CHECKPOINT on that database to force another log flush, and then recheck the value.
Log Flushes	The total number of log pages that were being written to disk by the log writer process during the specified time range.
Log Flushes Rate Total	Number of times per second that the log caches of all of the instance’s databases are being flushed to disk.
Log Growth Count	The number of times the log has been expanded for each database.
Log Growth Count Rate	The number of times per second the log has been expanded for each database.
Log Reads	Log cache lookups.
Log Shrink Count	The number of times the log has been reduced for each database.
Log Truncation Count	The total number of log truncations performed for each database during the specified time range. Log truncations can be carried out using either of the following methods: • Manual truncations (backup log <dbname> with truncate_only) • Automatic truncations — in either of the following settings: • The database has the trunc.log on chkpt. option turned on • The recovery model is set to Simple
Total Data Size	The amount of disk space that the data files are using.

Frequency Mode	Collection Interval (In Seconds)
Real-time	3600
Online	3600
Offline	86400

Display Name	Description
Ansi Null Default	Database follows SQL-92 rules for allowing null values.
Ansi Nulls	All comparisons to a null evaluate to unknown.
Ansi Padding	Strings are padded to the same length before comparison or insert.
Ansi Warnings	Error or warning messages are issued when standard error conditions occur.
Arithmetic Abort	Queries are ended when an overflow or divide-by-zero error occurs during query execution.
Auto Close	Database shuts down cleanly and frees resources after the last user exits.
Auto Create Statistics	Existing statistics are automatically updated when the statistics become out-of-date because the data in the tables has changed.
Auto Shrink	Database files are candidates for automatic periodic shrinking.
Auto Update Statistics	AUTO_UPDATE_STATISTICS database option is enabled.
Bulk Copy	Database allows non-logged operations.
Close Cursors On Commit	Cursors that are open when a transaction is committed are closed.
Collation	Default collation name for the database.
DB Name	The database’s name provides a unique identification of the database within a SQL Server instance.
DBID	The database’s ID provides a unique identification of the database within a SQL Server instance.
Full Text	Database is full-text enabled.
Local Cursors Default	Cursor declarations default to LOCAL.
Merge Published	The tables of a database can be published for merge replication, if replication is installed.
Null Concat	Null concatenation operand yields NULL.
Numeric Round Abort	Errors are generated when loss of precision occurs in expressions.
Quoted Identifiers	Double quotation marks can be used on identifiers.
Recovery	Recovery model for the database.
Recursive Triggers	Recursive firing of triggers is enabled.
Status	Database status.
Subscribed	Database is subscribed to a publication.
Page Verify	The SQL Server Database Engine detects incomplete I/O operations, resulting from power failures or other system outages. This metric indicates the method used by the database for detecting incomplete I/O operations, and has the following options: • None • Checksum — A sum derived from the bits of a segment of computer data, which is calculated before and after transmission or storage. • Torn page detection — detection of an incomplete I/O operation
Trunc Log	Database truncates its logon checkpoints.
Updateability	Indicates whether data can be modified.
User Access	Indicates which users can access the database.

Frequency Mode	Collection Interval (In Seconds)
Real-time	60
Online	300
Offline	3600

Display Name	Description
Available Databases	The number of available databases.
Data Files	Number of data files.
Data Files Size	Total size of the data files.
Data Files Space	Indicates the total size of the data files used and the data files maximum size in percent.
File Groups	Number of file groups.
Log Files	Number of log files.
Log Files Size	Total size of the log files.
Log Files Space	Indicates the total size of the log files used size and the log files maximum size in percent.
Unavailable Databases	The number of unavailable databases.

Display Name	Description
DB Name	The name of the database that contains the specified table.
FG Name	The file group where the table is stored.
Free MB	The amount of free space in the table.
Owner Name	The name of the table owner.
Percent Of DB	The percentage of space that the table occupies in the database.
Qualified Name	The full qualified name of the database object.
Reserved MB	The amount of space reserved for the table in megabytes.
Row ID	The row identifier.
Rows	The number of rows in the table.
Table MB	The actual size of the table in megabytes.
Table Name	The name of the table.
Used MB	The amount of used space in the table.

Frequency Mode	Collection Interval (In Seconds)
Real-time	300
Online	900
Offline	14400

Display Name	Description
# Index	The number of indexes that exist on the database.
# Table	The number of tables, where table type=user, which exist on the database.
Database	The name of the database, unique within an instance of SQL Server.
Database Unavailable Threshold	A threshold which, when exceeded, causes an alarm to fire regarding a specific database that is unavailable.
Days Since Last Backup	The number of days that passed since the last database backup.
Days Since Last Backup for Rule	A threshold which, when exceeded, causes an alarm to fire regarding the number of days that have elapsed since the last database backup.
Days Since Last Backup no Backup	A threshold which, when exceeded, causes an alarm to fire regarding a specific database that has never been backed up.
DBID	ID of the database, unique within an instance of SQL Server.
Last Backup	The date and time of the most recent backup of any type that has been carried out for the database.
Oldest Trans SPID	The system process ID of the session owning the oldest transaction in the database.
Oldest Trans Start Time	The date and time at which the oldest transaction in the database began.
Status	The status of the database can be one of the following: • Unavailable • Read Only • No Access • Normal.

Frequency Mode	Collection Interval (In Seconds)
Real-time	60
Online	300
Offline	300

Display Name	Description
Event Sequence	The event sequence number that identifies the deadlock occurrence.
Start Time	The time at which the deadlock event started.
Text Data	The XML data structure, holding the deadlock full data.

Frequency Mode	Collection Interval (In Seconds)
Real-time	20
Online	60
Offline	300

Display Name	Description
Aborted Transactions	The number of distributed transactions that were rolled back.
Active Transactions	The number of currently active distributed transactions.
Committed Transactions Sec	The number of distributed transactions committed per second.
In Doubt Transactions	Transactions that have passed phase 1 of the two phase commit (have committed the local transaction), and are awaiting a response from the DTC to either commit or roll back (phase 2).
Response Time Average	The average of the full time (in milliseconds) it has taken a query (select 1, by default) to get from the application to SQL Server and back.
Transactions Sec	The number of distributed transactions performed per second.

IMPORTANT: The Error Log Check collection retrieves information only for SQL Server 2005 and later.

Frequency Mode	Collection Interval (In Seconds)
Real-time	300
Online	300
Offline	900

Display Name	Description
Errors	The number of errors detected within the SQL Server error log, during the period specified for the collection frequency on the Databases > Administration > Collection Frequency view.
Check Date	Indicates the last date when the error log check was carried out.

NOTE: The list displays the logs in the following order: <log_name>-<log_files>-<log_size>.

Frequency Mode	Collection Interval (In Seconds)
Real-time	300
Online	900
Offline	3600

Display Name	Description
Archive No	The sequence number of the log creation, from low (current = 0) to high.
Created	The time when the file was created.
Log Files	The log file name and size.
Log Name	The name of the Archive log.
Log Size	The total size of the log, in megabytes.
Log Type	The log type: • SQL Server — in which case the log appears on the SQL Server Error Logs pane • SQL Agent — in which case the log appears on the SQL Server Error Logs pane

Display Name	Description
Log Date	The date when the error log message was created.
Message	The error log message.
Process Information ((in versions higher than 2000 - Error Number).	Displays the event to which the data refers (server process, SPID and so on).
Row ID	The row unique identifier.

Frequency Mode	Collection Interval (In Seconds)
Real-time	900
Online	900
Offline	14400

Display Name	Description
% Free	The percentage of space not allocated to any objects.
% Used	The percentage of space allocated to objects.
Can Grow	Indicates whether the file can grow.
Database	The database’s name provides a unique identification of the database.
DBID	The database’s ID provides a unique identification of the database.
File Count	The number of files in each file group.
File Group	The name of the file group to which the file belongs.
Free Size	The amount of unused space, measured in megabytes.
Size	The size of the file, in megabytes.
Type	The type of file group (for example: data or log).
Used Size	The size used by the database file (in megabytes).

Frequency Mode	Collection Interval (In Seconds)
Real-time	900
Online	900
Offline	14400

Display Name	Description
Current Reads Wait Time	The number of seconds SQL Server has spent waiting for physical read operations on this file since the last time data was collected. Shows data only for SQL Server 2005.
Current Wait Time	The number of seconds SQL Server has spent waiting for I/O operations on this file since the last time data was collected.
Current Writes Wait Time	The number of seconds SQL Server has spent waiting for write operations on this file since the last time data was collected. Shows data only for SQL Server 2005.
DB And File Group	The database name, concatenated with its file group name.
DB File Name	The database name, concatenated with its file name.
DB Name	The name of the SQL Server database that contains the file.
Disk	The disk where the file resides.
File Group	File group name.
File Name	The name of the file.
MB On Disk	Physical file size on disk in MB. Shows data only for SQL Server 2005.
MB Read	The number of MB read from this file since SQL Server started.
MB Written	The number of MB written to this file since SQL Server started.
Path	The name of the file whose I/O statistics are on display.
Reads	Number of reads issued on the file.
Reads Rate	The current rate at which SQL Server is performing physical read operations from this file.
Reads Wait Time	The total number of seconds SQL Server has spent waiting for physical read operations on the file since SQL Server started. Shows data only for SQL Server 2005.
Total IO	The number of MB read from and written to this file since SQL Server started (MB Read plus MB Written).
Total IO Rate	The current rate at which SQL Server is performing both physical read and write operations for this file (Reads Rate plus Writes Rate).
Total Wait Time	The total number of seconds SQL Server has spent waiting for I/O operations on this file since SQL Server started.
Writes	Number of writes issued on the file.
Writes Rate	The current rate at which SQL Server is performing physical write operations to this file.
Writes Wait Time	The total number of seconds SQL Server has spent waiting for write operations on the file since SQL Server started. Shows data only for SQL Server 2005.

Frequency Mode	Collection Interval (In Seconds)
Real-time	900
Online	900
Offline	14400

Display Name	Description
% Free	The percentage of space not allocated to any objects.
% Used	The percentage of space allocated to objects.
Can Grow	Indicates whether the file can grow.
Database	The database’s name provides a unique identification of the database.
DBID	The database’s ID provides a unique identification of the database.
File Count	The number of files in each file group.
File Group	The name of the file group to which the file belongs.
Free Size	The amount of unused space, measured in megabytes.
Size	The size of the file, in megabytes.
Type	The type of file group (for example: data or log).
Used Size	The size used by the database file (in megabytes).

Frequency Mode	Collection Interval (In Seconds)
Real-time	900
Online	900
Offline	14400

Display Name	Description
% Free	The percentage of space not allocated to any objects.
% Used	The percentage of space allocated to objects.
Auto Grow	Whether the file can grow automatically as it fills.
Can Grow	Indicates whether any of the files in the transaction log can grow.
Data Files Used Percentage Threshold	A flag indicating a threshold for the used percentage of space within a data file. When this percentage exceeds the predefined threshold, an alarm will be invoked.
Database	The name of the specified database.
DB and File	The database name, concatenated with the database file's name.
DBID	The database’s ID; provides a unique identification of the database.
File	The name of the data file.
File Group	The name of the file group to which the file belongs.
Free Size	The amount of unused space, measured in megabytes.
Growth Increment	Indicates the amount by which the file will grow every time, if the autogrow option is enabled. For example: if the data file’s initial size is 1 MB and it has to grow to a final size of 11 MB, setting the Growth Inc. parameter to 2 MB causes the file to grow five times, each time by a 2 MB increment.
Growth Remaining	The number of times a log file can grow automatically before the file is almost full and can no longer automatically grow enough to relieve the problem.
Growths Remaining Data File Threshold	A flag indicating a threshold for the number of times the data file can AutoGrow until it is unable to grow anymore.
Growths Remaining Log File Threshold	A flag indicating a threshold for the number of times a log file can AutoGrow until it is unable to grow anymore.
Log File Used Percentage Threshold	A flag indicating a threshold for the used percentage of space within a log file.
Path	The path of the database file.
Size	The file’s size.
Type	The type of file group. For example, data or log.
Used Size	The amount of space size used by the database file.

Frequency Mode	Collection Interval (In Seconds)
Real-time	900
Online	900
Offline	14400

Display Name	Description
Logical Disk	The logical drive name (for example: C, D).
Allocated Space	Total space (in megabytes) allocated to SQL Server files on the selected logical disk.
Used Space	Total space (in megabytes) used by SQL Server files on the selected logical disk.

Frequency Mode	Collection Interval (In Seconds)
Real-time	900
Online	900
Offline	18000

Display Name	Description
Allocated Space	Total space (in megabytes) allocated to SQL Server files on all drives, including the unoccupied space.
Used Space	Total space (in megabytes) used by SQL Server files on all drives.

Frequency Mode	Collection Interval (In Seconds)
Real-time	300
Online	900
Offline	14400

Display Name	Description
Database Name	The database’s name provides a unique identification of the database within a SQL Server instance.
FT Catalog ID	The ID of the full-text catalog, which uniquely identifies it across the full-text catalogs in the database.
FTC Name	The full-text catalog’s name provides a unique identification of the full-text catalog within a SQL Server instance.
FTC Status	The full-text catalog’s status can be one of the following: • 0 = Idle • 1 = Full population in progress • 2 = Paused • 3 = Throttled • 4 = Recovering • 5 = Shutdown • 6 = Incremental population in progress • 7 = Building index • 8 = Disk is full. Paused. • 9 = Change tracking
Populate CompleteAge	The difference in seconds between the completion of the last full-text index population and 01/01/1990 00:00:00. This value is updated only for full and incremental crawls, and returns 0 if no population has occurred.
Table Count	The number of tables in the database that take part in the full text indexing process.
Item Count	The number of full-text indexed items currently stored in the full-text catalog.
Index Size MB	Size of the full-text catalog in megabytes.
Path	Name of the catalog directory in the file system.

Frequency Mode	Collection Interval (In Seconds)
Real-time	20
Online	60
Offline	300

Display Name	Description
Active Time	Sum of all active wait events; equal to the session total activity within the specified time range.
Backup Recovery Wait	The average number of active sessions waiting for the completion of backup or recovery tasks during the selected time range.
CLR Wait	Time spent by the various sessions waiting for CLR code execution to complete.
CLR Wait Percent	Percentage of time spent by the various sessions waiting for CLR code execution to complete.
CPU Usage	Time spent by the various sessions consuming CPU cycles. This reading is taken directly from the operating system, rather than SQL Server wait states.
CPU Usage Percent	Percentage of time spent by the various sessions consuming CPU cycles. This reading is taken directly from the operating system, rather than from SQL Server wait states.
CPU Usage Rate	Percentage of time spent by the various sessions waiting for CLR code execution to complete.
CPU Wait	Time spent by the various sessions waiting in the systems run queue for CPU cycles. This reading is calculated from the operating system readings, rather than SQL Server wait states.
CPU Wait Percent	Time spent by the various sessions waiting in the system's run queue for CPU cycles. This reading is taken directly from the operating system, rather than from SQL Server wait states.
CPU Wait Rate	Time spent per second by the various sessions waiting in the system's run queue for CPU cycles. This reading is taken directly from the operating system, rather than from SQL Server wait states.
Cursor Synchronization Wait	Time spent by the various sessions waiting for cursor synchronization operations to complete.
Cursor Synchronization Wait Rate	The average number of active sessions waiting for the completion of cursor synchronization operations during the specified time range.
Database Replication Wait	Time spent by the various sessions waiting for replication synchronization events to complete.
Deferred Task Worker Wait	Time spent by the various sessions waiting for I/O requests; this wait indicates that either a large number of suspect pages are encountered or the disk subsystem is overloaded.
Distributed Transaction Wait	Time spent by the various sessions waiting for various distributed transaction events to complete.
External Procedure Wait	Time spent by the various sessions waiting for external procedures to end.
Full Text Search Wait	Time spent by the various sessions waiting for full text synchronization operations.
Hosted Components Wait	Time spent by the various sessions waiting for hosted components, such as, but not exclusively, CLR.
I/O Bulk Load Wait	Time spent by the various sessions waiting for a bulk load I/O to finish.
I/O Completion Wait	Time spent by the various sessions waiting for I/O operations to complete.
I/O Data Page Wait	Time spent by the various sessions waiting to latch a buffer for an I/O request; this wait is related to issues with the disk I/O subsystem.
I/O Wait	Time spent by the various sessions waiting for physical I/O operations to complete.
Idle	Idle time.
Internal Cache Latch Wait	Time spent by the various sessions waiting for latches that are not buffer latches or savepoint latches. Typically, this event can only be treated by partitioning data to provide more cache pages.
Latch Buffer Wait	Time spent by the various sessions waiting to latch a buffer that is not an I/O request.
Latch Savepoint Wait	Time spent by the various sessions waiting to synchronize commits to marked transactions.
Latch Wait	Time spent waiting for internal locks (latches) to be released.
Lock Bulk Update Wait	Time spent by the various sessions waiting to acquire bulk update locks.
Lock Exclusive Wait	Time spent by the various sessions waiting to acquire exclusive locks.
Lock Intent Wait	Time spent by the various sessions waiting to acquire intent locks.
Lock Schema Wait	Time spent by the various sessions waiting to acquire schema locks.
Lock Shared Wait	Time spent by the various sessions waiting to acquire shared locks.
Lock Update Wait	Time spent by the various sessions waiting to acquire update locks.
Lock Wait	Time spent by the various sessions waiting for a blocking lock (held by another session) to be released.
Log Buffer Wait	Time spent by the various sessions waiting for space in the log buffer or otherwise waiting for memory to be made available to write log records.
Log Other Wait	Time spent by the various sessions waiting for miscellaneous logs.
Log Synchronization Wait	Time spent by the various sessions waiting to see whether log truncation frees log space.
Log Wait	Time spent waiting by the various processes waiting for a Log operation to complete.
Log Write Wait	Time spent by the various sessions waiting for outstanding I/Os to finish, or waiting for log flushes to complete.
Memory Wait	Time spent by the various sessions waiting for memory resources to be made available.
Network HTTP Wait	Time spent by the various sessions waiting for outstanding HTTP connections to complete and exit.
Network I/O Wait	Time spent by the various sessions waiting for network packets.
Network IPC Wait	Time spent by the various sessions waiting for sub-tasks to generate data; long waits are indicative of unexpected blockages.
Network Mirror Wait	Time spent by the various sessions waiting for sub-tasks to generate data; long waits are indicative of unexpected blockages.
Network Wait	Time spent by the various sessions waiting for network I/O operations to complete.
Network Wait Percent	Percentage of time spent by the various sessions waiting for network I/O operations to complete.
Non CLR Wait	Overall active time that does not include CLR wait time.
Non CLR Wait Rate	The average number of active sessions waiting for all wait events, excluding CLR wait, during the specified time range.
Non CPU Wait	Overall active time that does not include CPU wait time.
Non CPU Wait Rate	The average number of active sessions waiting for all wait events, excluding CPU wait, during the specified time range.
Non I/O Wait	Overall active time during the specified time range, excluding time spent on I/O-related wait events.
Non Latch Wait	Overall active time during the specified time range, excluding time spent on latch-related wait events.
Non Latch General Wait	Overall active time during the specified time range, excluding time spent on general latch-related wait events.
Non Lock Wait	Overall active time during the specified time range, excluding time spent on lock-related wait events.
Non Log Wait	Overall active time during the specified time range, excluding time spent on log-related wait events.
Non Memory Wait	Overall active time during the specified time range, excluding time spent on memory-related wait events.
Non Network Wait	Overall active time during the specified time range, excluding time spent on network-related wait events.
Non Other Wait	Overall active time during the specified time range, excluding time spent on general other wait events.
Non Remote Provider Wait	Overall active time during the specified time range, excluding general remote provider wait time.
OLEDB Provider Full Text Wait	Time spent by various processes waiting for the Microsoft Full Text Engine for SQL Server.
Other Miscellaneous Wait	Time spent by the various sessions waiting for miscellaneous database operations.
Other Wait	Miscellaneous instance waits consisting of infrequent or otherwise special purpose wait states that should, in most cases, be very close to 0.
Parallel Coordination Wait	Time spent by the various sessions waiting for parallel coordination tasks to complete. This is the time spent by the various processes coordinating parallel query threads and exchanging data.
Remote Provider Wait	The time spent by the various processes waiting for a remote OLEDB call to complete or DTS synchronization.
Service Broker Wait	Time spent by the various sessions waiting for Service Broker event handlers and endpoints.
Synchronous Task Wait	Time spent by the various sessions waiting for tasks started synchronously (most SQL Server processes are started asynchronously).
XTP Transaction Wait	Time spent waiting for in-memory transaction events.
XTP Wait	Time spent waiting for in-memory OLTP (XTP) related events.
XTP Miscellaneous Wait	Time spent waiting for in-memory miscellaneous events. Those events are not related to transactions, log or natively compiled stored procedures.
XTP Log write Wait	Time spent waiting for in-memory log and checkpoint related events.
XTP Procedure Wait	Time spent waiting for events related to natively compiled stored procedures.

Frequency Mode	Collection Interval (In Seconds)
Real-time	20
Online	60
Offline	300

Display Name	Description
Wait Event Name	Internal wait event name.
Wait Time	Total wait time for this wait event type, in seconds.

Display Name	Description
Message	Text, if any, of a SQL Server error.
Step Name	The name of the step.
Step ID	The ID of the step in the job.
SQL Message ID	ID of any SQL Server error message, which is returned if the job failed.
SQL Message Severity	The severity of any SQL Server error.
Run Status	Status of the job execution. The run status can have one of the following values: • Failed • Success • Retry • Canceled • In progress
Message Time	The date and time when the job or step started execution. For an In Progress history, this is the date and time when the history was written.
Run Duration	The time, in seconds, which has elapsed since the beginning of the execution of the job or step format.

Frequency Mode	Collection Interval (In Seconds)
Real-time	20
Online	60
Offline	300

Display Name	Description
Average Latch Hit Wait Time	The wait time of latch requests that were satisfied.
Average Lock Duration	Average duration of blocked lock requests (100 * Lock Wait) /Blocked Lock Requests.
Average Lock Requests Wait Time
Average Lock Wait Time	The average wait time, in milliseconds, of lock requests that were satisfied.
Blocked Lock Requests	Number of lock requests that could not be satisfied immediately, causing the caller to block and wait before acquiring the lock.
Blocked Lock Requests Ratio	The percentage of lock requests that required the caller to wait before acquiring the lock. A high percentage (over 20 percent), along with high Lock Wait, indicate that the system is not handling locks well and concurrency mechanisms need to be tuned. Excessive blocking can be a major cause of poor application performance, as the user of an application often does not realize that they are waiting on a lock held by another user. From their point of view, it often seems like their application has stopped responding. (100 * Blocked Lock Requests) / Lock Requests
Latch Wait Count	Number of latch requests that could not be satisfied immediately, causing the caller to block and wait before acquiring the latch.
Lock Requests	Number of new locks and lock conversions requested from the lock manager.
Lock Timeouts	The number of lock timeouts. By default, SQL Server never times out locks. However, many applications issue a SET LOCK_TIMEOUT statement to cause SQL Server to time out their locks after the specified interval. This metric shows how often these timeouts are being exceeded.
Lock Timeouts Bigger Than Zero	The number of lock timeouts. By default, SQL Server never times out locks (they will wait forever). However, many applications issue a SET LOCK_TIMEOUT statement to cause SQL Server to timeout their locks after the specified interval. This metric shows how often these timeouts are being exceeded.
Lock Wait Time	Total wait time, in milliseconds, for all lock requests that resulted in a wait.
Number Of Deadlocks	The number of lock requests that resulted in a deadlock. A Deadlock occurs when multiple SQL Server sessions request conflicting locks in such a way that two locks are blocked by one another.
Number Of Super Latches	Number of latches that are currently SuperLatches. Super Latches (or Sub-Latches) are latches that are generally used when data is accessed frequently (latches that are in shared lock mode (SH)). A regular latch is often “Promoted” to a Super/Sub latch in order to reduce the latch acquired on each lookup. Thus, when data is accessed many times for carrying out a read-only operation, the “newly promoted” Super/Sub latch will handle all requests for this data. An example to a Super/Sub latch would be an index root page accessed frequently.
Super Latch Demotions	Number of SuperLatches that have been demoted to regular latches. A latch is demoted when SQL Server determines that no thread requests a data help by Super/Sub latch, or when SQL Server needs to write to that data resource and need to acquire exclusive access to that source.
Super Latch Promotions	Number of latches that have been promoted to SuperLatches. A regular latch is often “Promoted” to a Super/Sub latch in order to reduce the latch acquired on each lookup. Thus, when data is accessed many times for carrying out a read-only operation, the “newly promoted” Super/Sub latch will handle all requests for this data. An example to a Super/Sub latch would be an index root page accessed frequently.
Total Latch Wait Time	The total amount of time, in milliseconds, that latch requests spent waiting during the last second.

Frequency Mode	Collection Interval (In Seconds)
Real-time	20
Online	60
Offline	300

Display Name	Description
Deadlocks	The total number of deadlocks for the lock type. A Deadlock occurs when multiple SQL Server sessions request conflicting locks in such a way that two locks are blocked by one another.
Lock Requests	The summary of all lock requests, both for new locks and lock conversions.
Lock Timeouts	The number of lock requests per second that timed out, including requests for NOWAIT locks.
Lock Type	The name of the lock type.
Total Wait Time (seconds)	The total lock wait time for the lock type.
Total Waits	The total number of wait events for the selected lock type.

Frequency Mode	Collection Interval (In Seconds)
Real-time	60

Display Name	Description
SPID	The server process ID of the current user process.
Login Time	The time the session was created.
Login Name	SQL Server Login name.
Database	The database that is being used by the current process.
Index Name	The index that is being used by the current process (if any).
Object Name	The name of the currently locked object.
Count	The number of locks that share the same object and type.
Lock Type	The type of the resource that is currently being locked (Database, Table, Page, Row, Extent and so on).
Mode	The kind of lock that is being applied to the resource (Shared, Exclusive, Update, IntentShared, IntenExclusive and so on).
Status	The status of the lock can be one of the following: • WAIT = wait for another resource • CNVT = converted to another resource • GRANT = the lock has granted

Frequency Mode	Collection Interval (In Seconds)
Real-time	20

Display Name	Description
SPID	The SQL process ID of the process that ran the query.
Rowset Key	The row identifier.
Owner	The current primary server.
Server Name	The name of the server (primary server for the parent node, and secondary server for all subsequent child nodes).
Database Name	Refers to either of the following databases: • For the parent node, this is the database that is backed up on the source server. • For each child node(s), this is the destination database on the secondary server.
Flag Error	An indicator of an error that occurred.
Threshold	The maximum allowed time (in minutes) before a Log Shipping alert occurs. This parameter can refer to either of the following values: • For each parent node, this is the maximum allowed time since the last transaction log backup was made on the source server. • For each child node, this is the maximum allowed time between the last backup on the source server and the last restore on the secondary server.
Threshold Alert	The alert displayed in the Error Log drilldown if the threshold is exceeded.
Threshold Alert Enabled	The alert displays only if it is enabled.
Last Change	This parameter can refer to either of the following values: • For the parent node, this is the last time that the database was backed up. • For the child node(s), this is the last time a file was copied or restored. The Activity Type field displays this information.
Last Change Type	The type of the activity that resulted in the log shipping’s most recent change of state (Backup, Copy or Restore).
Last Backup Filename	The name of the file that was most recently backed up.
Last Backup Last Updated	The time at which the most recent backup operation was carried out.
Outage	During an outage, no alerts will occur when thresholds are exceeded (for both the parent and child nodes). If this field is blank, no outage will take place.
Backup In Sync	Indicates either of the following backup statuses: • The backup is in sync mode. • The backup is out of sync and needs to be synchronized.
Backup Delta	The last time a log transaction backup occurred in the primary server.
Last Copied Filename	The last backup file that was copied to the secondary server.
Last Copied Last Updated	The time when the backup file was most recently copied from the primary to the secondary server.
Last Loaded Filename	The name of the backup file that was most recently restored to the secondary server.
Last Loaded Last Updated	The time when the backup file was most recently restored to the secondary server.
Copy Delta	The date when the transaction log backup file was most recently copied to the secondary server.
Copy Enabled	Indicates whether copying is enabled.
Load Enabled	Indicates whether loading is enabled.
Load in Sync	The load synchronization can have either of the following statuses: • The load is in sync mode. • The load is out of sync and needs to be synchronized.
Load Delta	The date of the last restored transaction log load file to the secondary server.
Primary Server Time	The current timestamp at the primary server.
Secondary Server Time	The current timestamp at the secondary server.
Monitor Server Time	The current timestamp at the monitored server.

Frequency Mode	Collection Interval (In Seconds)
Real-time	20
Online	60
Offline	300

Display Name	Description
Disk Queue Length	Disk Queue length tracks the average number of I/O requests, from all disks in the system, which are queued and waiting for a disk during a sampled interval. This figure may include I/O activity generated by processes other than SQL Server. Values that exceed the threshold set in this metric indicate a bottleneck.
Disk Queue Length Threshold	A flag indicating a threshold for the number of I/O requests that were outstanding on the busiest disk in the system.
Disk Percentage Used	The percentage of used space on the specified partition.
Disk Partition	The logical disks to which the Disk Queue Length value refers.
Partition Free Pct	The percentage of free space on the specified partition.
Partition Free Space	The amount of free space (in megabytes) on the specified partition.
Partition Total Space	The total space (in megabytes) on a particular partition.

Frequency Mode	Collection Interval (In Seconds)
Real-time	20
Online	60
Offline	300

Display Name	Description
% Total Server Memory	The total percentage of dynamic memory that the server is currently consuming. This value is calculated as follows: 100 * (Total Server Memory / Physical RAM)
Cache Memory	Total amount of dynamic memory (in megabytes) that the server is using for the dynamic SQL cache.
Connections Memory	Memory (in megabytes) allocated to keeping track of each connection's attributes.
Locks Memory	Memory (in megabytes) allocated to keeping track of locks.
Max SQL Server Memory	The maximum amount of dynamic memory that the instance is allowed to consume.
Memory Growth Pressure	Relative amount of additional memory (presented as a percentage) that SQL Server is willing to consume. Values higher than 20 percent might indicate that the system is low on physical memory. The memory growth pressure value is calculated as follows: 100 – ((100 * Total Server Memory) Target Server Memory)
Optimizer Memory	Work area for the Optimizer in megabytes.
Sort Hash Memory	Memory in megabytes used for the Sort, Hash, and Index operations.
Target Server Memory	The maximum memory allocation size in megabytes SQL Server can reach at a current time (this value may change during SQL Server's work). Values significantly higher than Total Server Memory might indicate that the system is low on physical memory.
Total Server Memory	The total amount of dynamic memory (in megabytes) that the server is currently consuming.

Frequency Mode	Collection Interval (In Seconds)
Real-time	300
Online	300
Offline	900

Metric Display Name	Description
Connection Timeout	Defines the number of seconds that the principal database can be in Disconnected state, before the mirroring session will actually run a failover scenario to the mirroring database.
Database Name	The name of the database.
End Log LSN	The actual LSN (Log Sequence Number) of the mirroring session, This value should be equal to the Failover LSN value.
Failover LSN	The LSN (Log Sequence Number) value that the mirroring database should have in order to enable a smooth failover.
Mirror	The name of the instance whose role in the mirroring process is Mirror.
Mirroring Role	The role the database takes in the mirroring process; either principal or mirror.
Mirroring Status	Indicates the severity determined based on the database state: Normal, Warning or Critical.
Partner Name	The server network address defined for the Partner.
Principal	The name of the instance whose role in the mirroring process is Principal.
Redo Queue	The redo queue size. This size can be either lett Unlimited or defined in MB.
Replication LSN	The LSN (Log Sequence Number) used by the replication session (If such a session exists).
Role Sequence	A cumulative number that indicates the number of role switches that took place between the two partners involved in the mirroring process.
Safety Level	The safety level at which the mirroring session is configured to work (high availability /high performance).
Witness Name	The server network address defined for the Witness.
Witness State	The state of the Witness instance (valid only when the High Safety level is configured).

Frequency Mode	Collection Interval (In Seconds)
Real-time	300
Online	300
Offline	900

Display Name	Description
Commit Acknowledgment Delay	Indicates a delay in waiting for acknowledgement of unterminated transaction commit. This metric is specific to the principal database, and holds values only when a Full safety level is configured.
Database Name	The name of the database.
Log Remaining For Undo	Indicates the size of transaction logs in the mirror database that remain for recovering the mirror database to its operative state. This metric holds data only after a failover has occurred.
Log Cache Redone	The amount of transaction log in MB that is being read from redo cache rather than from the transaction log. Constantly low values of this metric indicate that the transaction log is arriving faster than it can be read by the redo task. This metric is specific to the mirror database.
Log Harden Wait Time	The amount of time spent waiting for the log to be written to the mirroring database. High values of this metric can indicate that the disk of the mirroring database is loaded. This value is specific to the mirror database.
Log Received	Indicates the rate in MB of log received from the principal database. This metric is specific to the mirror database.
Log Rolled Forward	The size in MB of log that was rolled forward on the mirror database. This value is specific to the mirror
Log Scanned For Undo	Indicates the size of transaction logs in the mirror database that were scanned for Undo. This metric holds data only after a failover has occurred, as the log scanning is carried out in order to restore the mirror database to its operative state.
Log Send Flow Buffer Wait	The amount of time the mirroring session had to wait to use the mirroring flow control buffer. This value is specific to the principal database.
Log Sent	Indicates the rate in MB of log sent from the principal to the mirror database. This metric is specific to the principal database.
Log Sent From Cache	Indicates the amount of log, in MB, sent from the principal database cache rather than straight from the transaction log. As sending from the cache is much faster and more efficient, this metric's values should be as high as possible. Constantly low values indicate that the transaction log generation rate is faster than the rate at which it is sent to the mirror database. This value is specific to the principal database.
Mirroring Roundtrip (Latency)	Indicates the latency of the mirroring session.
Occupied Cache Percent	The percentage of the occupied cache within the selected database.
Roll Forward Queue	Total size in MB that remains to roll forward to the mirroring database. This value is specific to the mirror database.
Send Queue	Total size in MB of data waiting to be sent to the mirroring database. This value is specific to the principal database.
Write Commit	This metric, which holds values only when a Full safety level is configured, indicates the number of transactions in the principal database that had to wait for a write commit in the mirror database's transaction log. Low values of this metric indicate a bottleneck.

Frequency Mode	Collection Interval (In Seconds)
Real-time	60

Display Name	Description
Allocated Size	The amount of space in the procedure cache (in megabytes) that is allocated to this object.
Cache Object Type	The type of object in the cache. This metric can have one of the following values: • Compiled Plan • Executable Plan • Parse Tree • Extended Stored Procedure
Database	The database where the object resides.
From Cache	Percent of memory consumed by the cache object as part of the whole plan cache memory.
Object	The object name.
Object Type	An object can have one of the following types: • Stored procedure • Prepared statement • Ad hoc query1 • ReplProc • Trigger • View • Default • User table • System table • Check • Rule
Owner	The object owner.
Reference Count	The number of other cache objects that reference this cache object.
SQL Text	The name of the procedure, or the first 128 bytes of the batch submitted.
SQL Text Size	Object size in bytes.
Use Count	The number of times this cache object has been used since inception.
Used Date Format	The date format used by the connection that created the cache object.
Used Language	The language of the connection that created the cache object.

Frequency Mode	Collection Interval (In Seconds)
Real-time	60
Online	300
Offline	300

Display Name	Description
Agent Name	The name of the replication agent.
Average commands	Average number of commands per transaction delivered in the session.
Delivery Latency	Latency, in milliseconds, between the transaction entering the distribution database and being applied to the Subscriber.
Delivery Rate	Average number of commands delivered per second.
Duration	The elapsed time of the agent's last session.
Publication DB Name	The name of the publication database, whose data is replicated using the selected agent.
Publication Name	The name of the publication replicated using the selected agent.
Publishing Server	The name of the SQL Server instance that hosts the publication database, whose data is replicated using the selected agent.
Start Time	The time when the selected session started.
Status	The selected agent’s current status; for example, Started, Completed, Running, Idle, Retrying, and Error.
Subscribing Server	The name of the SQL Server instance that hosts the Subscription database to which data is replicated using the selected agent.
Subscription DB	The name of the Subscription database to which data is replicated using the selected agent.
Subscription Type	Type of subscription; for example, Push, Pull, and Anonymous.
Type	The type of the selected agent; for example, Distribution, Log Reader, Snapshot, Merge, Miscellaneous.

Frequency Mode	Collection Interval (In Seconds)
Real-time	60
Online	300
Offline	300

Display Name	Description
Agent Name	The name of the replication agent.
Message	All informational messages and error messages that the selected agent has logged during the selected session.
Session Start Time	The time when the selected session started.
Time	The time at which the action described in the Message column was performed.

Frequency Mode	Collection Interval (In Seconds)
Real-time	60
Online	300
Offline	300

Display Name	Description
Article Name	The name of a specific article (a table or other object) that is part of the publication.
Counter for Conflicts	The total number of conflicts detected when trying to replicate the selected article.
Counter for Deletes	The total number of Delete operations that were replicated.
Counter for Inserts	The total number of Insert operations that were replicated.
Counter for Retries	The total number of retrial attempts performed when trying to replicate this article.
Counter for Schema Changes	The total number of schema changes detected.
Counter for Updates	The total number of Update operations that were replicated.
Duration	The amount of time the article replication took.
Merge Agent Name	The name of the selected Merge agent.
Percent of Total	The currently completed percent of the article replication operation.
Session Start Time	The time when the selected Merge session started.
Status	The Status of the Merge agent. The possible values are: Started, Completed, Running, Idle, Retrying, and Error.

Frequency Mode	Collection Interval (In Seconds)
Real-time	60
Online	300
Offline	300

Display Name	Description
Actions	Number of actions (comments) written per session.
Agent Name	The name of the selected agent.
Commands	The aggregated number of commands that were processed during the selected session's run.
Duration	Amount of time the agent has run in this session. The time represents elapsed time if the agent is currently running and the total time of the session if the agent session has ended.
End Time	The time the selected non-active session ended.
Last Message	All informational and error messages logged by the agent during the selected session.
Session Start Time	The time the selected non-active session started.
Status	Status of the agent session; for example, Started, Completed, Running, Idle, Retrying, and Error.
Transactions	The aggregated number of transactions that were processed during the selected session's run.
Type	The replication agent type.

Display Name	Description
Actions	Number of actions (comments) recorded per session.
Agent Name	The name of the selected agent.
Commands Processed	The aggregated number of commands that were processed during the selected session's run.
Duration	Amount of time the agent has run in this session. The time represents elapsed time if the agent is currently running and the total time of the session if the agent session has ended.
End Time	The time the selected active session ended.
Last Message	All informational and error messages logged by the agent during the selected session.
Start Time	The time the selected active session started.
Status	Status of the agent session; for example, Started, Completed, Running, Idle, Retrying, and Error.
Transactions Processed	The aggregated number of transactions that were processed during the selected session's run.
Type	The replication agent type.

Frequency Mode	Collection Interval (In Seconds)
Real-time	20
Online	60
Offline	300

Display Name	Description
Replication Available	Indicates whether replication is available.

Frequency Mode	Collection Interval (In Seconds)
Real-time	300
Online	900
Offline	900

Display Name	Description
Due to Expire	Displays the time and date when the subscription expires if changes recorded in the distribution database are not yet synchronized with the subscribing server.
Errors	Number of errors encountered when synchronizing with the publication.
Last Synchronized	Retention period of the publication, in hours. Indicates the predefined distribution retention period. If by the end of this period there are changes in the distribution database that have not been delivered to the subscribing server and synchronized, the subscription expires and has to be re-initialized.
Log Reader Agent	Name of the Log Reader agent, if applicable.
Publication DB Name	The name of the database that contains the selected publication.
Publication Name	The name of the currently selected publication.
Publishing Server Name	The name of the SQL Server instance that hosts the selected publication database.
Queue Reader Agent	Name of the Queue Reader agent, if applicable.
Snapshot Agent	Name of the Snapshot Agent job for the publication.
Status	Highest (worst) severity status of the agents associated with the publication. For example, Started, Succeeded, In progress, Idle, Retrying, and Failed.
Subscriptions	Number of subscriptions for the selected publication.
Synchronizing	Number of subscriptions currently being synchronized with the publication.
Type	The selected publication's type; for example, Transaction, Snapshot, or Merge.
Warnings	Number of publication monitor threshold warnings generated by the selected publication.

Frequency Mode	Collection Interval (In Seconds)
Real-time	300
Online	900
Offline	900

Display Name	Description
Distribution / Merge Agent	Name of the Distribution or Merge Agent for the subscription.
Latency	Highest latency, in seconds, for data changes propagated by the Log Reader or Distribution Agents for a transactional publication.
Log Reader Agent	Name of the Log Reader agent, if applicable.
Publication DB	The name of the database, which contains the publication that is replicated to the selected subscription
Publication Name	The name of the publication replicated to the selected subscription.
Publication Type	The type of publication replicated to the selected subscription; for example, Snapshot, Transactional, and Merge.
Publishing Server Name	The name of the SQL Server instance that hosts the selected publication database, whose data is replicated to the selected subscription.
Snapshot Agent	Name of the Snapshot Agent job for the publication.
Status	Highest (worst) severity status of the agents associated with the replication. For example, Started, Succeeded, In progress, Idle, Retrying, and Failed.
Subscribing Server	The name of the SQL Server instance that hosts the database where the selected Subscription resides.
Subscription DB	The name of the SQL Server instance that hosts the database where the selected Subscription resides.
Subscription Type	The selected subscription's type; for example, Push, Pull, Anonymous.

Display Name	Description
Active	Indicates whether the process is active.
Blocked By	Which SPID (if any) holds locks that this session is waiting on (Blocked By).
CPU Usage	The Total CPU time that this session has used since connecting to the SQL Server.
Cache Hit Ratio	The percentage, for this session, of buffer cache hit ratio, that is: file read operations that were satisfied by the file system cache without requiring any physical I/O. The value of this metric should be as high as possible.
Context Info	Provides context information for the current session.
Current Wait Time	The amount of time this session has been waiting. This shows 0 if the session is not currently waiting.
DB User	The SQL Server login name for this session.
Database	The name of the database where the session is running.
Error Number	Indicates if the most recent statement completed by this session returned an error number; corresponds to the @@Error global variable for this session. Can have two states: • Zero value - no error was returned • Positive value - an error was returned; the corresponding error text will be shown.
Host Name	The name of the Client host that is running the session.
Last Batch Time	The time the last batch started execution (Last Batch Time).
Last Command	The current or previous command executed.
Lock Timeout	The amount of time that this session waits for lock requests to be satisfied. Corresponds to the @@Lock_Timeout global variable for this session.
Logical Reads	Indicates the number of logical reads per second currently being performed by this session. Logical reads are database page I/O requests that were satisfied from the Buffer Cache and therefore did not have to perform disk reads.
Login Time	The time the session was created.
Memory	Memory is the number of pages in the procedure cache that are currently allocated to this process. A negative number indicates that the process is freeing memory allocated by another process.
Most Recent SQL	Shows the batch of SQL statements last executed or currently executing by the selected session.
Physical Reads	Shows the number of physical reads per second currently being performed by this session.
Physical Writes	Shows the number of physical writes per second currently being performed by this session.
Program	The Program that the user is running in order to access SQL Server.
SPID	The SQL process number.
Status	The session Status (runnable, sleeping, blocked and so on).
System Process	A flag indicating the session type: • Y= a system session • N = a non-system session.
Total I/O	The total amount of I/O operations (including background I/O) performed by the session from the time it connected to the SQL Server.
Transaction Count	The number of open transactions; corresponds to the session's @@TRANCOUNT value.

Display Name	Description
SPID	The session unique identifier (Session Process ID). The unique number that SQL Server has assigned to identify the selected session.
Start Time	The time when the class event started.
End Time	The time when the class event ended.
Event Class	The type of class that was traced.
Duration	The duration, in milliseconds, of the event class.
Text Data	The SQL text that was captured as a result of the trace event.
Reads	The number of logical disk reads carried out by the server on behalf of the event.
Writes	The number of physical disk writes carried out by the server on behalf of the event.
CPU	The amount of CPU time (in milliseconds) used by the event.
Database ID	ID of the current database.
Object Name	System-assigned ID of the object.
Index ID	ID for the index on the object affected by the event.

Frequency Mode	Collection Interval (In Seconds)
Real-time	20
Online	60
Offline	300

Display Name	Description
Active Connections Percent	The percentage of active connections as part of the user sessions.
All Active Connections	The number of all SQL active connections.
Background Sessions	The total number of background sessions.
Blocked Connections	The total number of blocked sessions.
Blockers Connections	The total number of blocking sessions.
Connections Running DBCC	The total number of sessions running a DBCC command.
Foreground Sessions	The total number of foreground sessions.
Internal Connections	The number of internal connections of the SQL Server instance.
Machine Connections	The number of Client computers that currently have at least one SQL Server session.
Max Block Time	The maximum duration (in seconds) a current process was blocked.
Max Connections Allowed	The maximum number of user connections that SQL server allows.
Max Threads Allowed	The maximum number of threads that SQL server is configured to handle.
SQL Active Threads	The total number of the instance’s currently active threads.
SQL Executions	The total number of time that the selected statement executed during the specified time range. NOTE: This data is available only if StealthCollect is installed and configured
System Connections	The number of SQL Server system sessions.
Total Connections	The total number of SQL Server sessions, including user and system sessions.
User Active Connections	The number of non-system sessions that are actively processing in SQL Server or that are waiting on locks.
User Connections	The number of SQL Server user (non-system) sessions, excluding SQL Server Agent sessions.
User Inactive Connections	The number of non-system sessions that are not actively processing in SQL Server.
Worker Threads Used Percent	The percentage of active threads out of the maximum number of threads that SQL server is configured to handle.

Frequency Mode	Collection Interval (In Seconds)
Real-time	20
Online	60
Offline	300

Display Name	Description
CPU Busy	The total time the SQL Server instance has spent working since it was last started. The result is displayed in CPU time increments, or “ticks”, and is aggregated for all CPU units, so it may exceed the actual elapsed time. NOTE: To convert the value to microseconds, multiply it by @@TIMETICKS.
CPU Idle	The total time the SQL Server instance has been idle since it was last started. The result is displayed in CPU time increments, or “ticks”, and is aggregated for all CPU units, so it may exceed the actual elapsed time. NOTE: To convert the value to microseconds, multiply it by @@TIMETICKS.
I/O Errors	The number of I/O errors encountered by SQL Server during the specified time range.
Instance Packet Errors	The number of packet errors encountered by SQL Server during the specified time range.
Instance Packets In	The total number of network packets that were being sent to SQL Server from client applications during the specified time range.
Instance Packets Out	The total number of network packets that were being sent from SQL Server to Client applications during the specified time range.
Instance Packets Total	The rate at which network packets are being sent and received from SQL Server to client applications.
Instance Packet Errors	The rate at which SQL Server is encountering network packet errors.
Total Read Rate	Total number of physical reads carried out by SQL Server since the instance was last started.
Total Write Rate	Total number of physical writes carried out by SQL Server since the instance was last started.

Frequency Mode	Collection Interval (In Seconds)
Real-time	20
Online	60
Offline	300

Display Name	Description
CPU Name	The unique identifier of the CPU within all CPUs.
CPU Usage	Time spent by the various sessions that consume CPU cycles. This reading is taken directly from the operating system, rather than from SQL Server wait states.
Disk Utilization	The percentage of time the busiest disk spent serving system-wide I/O requests. This metric serves as a measure for the system I/O load. High values may indicate device bottleneck.
Free Virtual Memory	The current amount of virtual memory available in percent.
Individual CPU Usage	CPU utilization of a single processor.
Memory Max Percent	The maximum memory, in percent, which SQL Server can obtain from the host physical memory.
Network Bandwidth	The total network bandwidth used capacity of the specified network card in percent.
Network Interface	The name of the network interface.
Network Total Bandwidth	The total network bandwidth capacity of the specified network card.
Network Used Bandwidth	The total network bandwidth used capacity of the specified network card.
Physical Host	Physical name of the SQL Server instance host machine.
Physical Memory	The amount (in megabytes) of host physical memory.
Physical Memory Available	The amount (in megabytes) of physical memory available to applications.
Physical Memory Used	The amount (in megabytes) of physical memory used by applications.
Physical Memory Used Percent	The amount (by percentage) of physical memory used by applications.
Process CPU Utilization	Indicates the CPU use by a single process.
Run Queue Length	System average run queue. The CPU run queue is a holding area for threads and processes that require the CPU when the CPU is busy serving other processes. The run queue length is an indicator of whether the system has sufficient CPU resources for all the processes it executes. High values, along with high CPU utilization, indicate that the system requires faster or additional CPU units to handle the given load.
Total Virtual Memory	The current amount of total virtual memory.
Used Virtual Memory	The current amount (in megabytes) of used virtual memory.

Frequency Mode	Collection Interval (In Seconds)
Real-time	20
Online	60
Offline	300

Display Name	Description
Attempted Connections	Number of attempted connections, either successful or unsuccessful since SQL Server was last started.
Session Logons	Number of sessions whose activity started during the current interval.
Session Logons Delta Rate Calculation	The rate per second of sessions whose activity started during the current interval.

Frequency Mode	Collection Interval (In Seconds)
Real-time	60
Online	300
Offline	3600

Display Name	Description
Analysis Services	The status of Analysis Services service.
Cluster Servers Down	Number of cluster nodes that are down or unreachable.
Distributed Transaction Coordinator	The status of Distributor Transaction Coordinator service.
Integration Services	The status of SQL Server Integration Services service.
Last Alert	Number of alerts raised by SQL Server since the specified time.
Last Job Failed	Number of failed jobs since the specified time.
Log Shipping	The status of Log Shipping.
MS Full Text Search	The status of MS Full Text Search service.
Non Preferred Node	Number of cluster nodes that are declared as preferred servers.
Reporting Services	The status of SQL Server Reporting Services service.
SQL Agent	The status of SQL Agent service.
SQL Server Active Directory Helper	The status of SQL Server Active Directory Helper (ADH) service.
SQL Server Browser	The status of SQL Server Browser Service.
SQL Server Mail	The status of SQL Server Mail service.
SQL Server VSS Writer	The status of SQL Server VSS writer Service.
State Changed	The time the service state was last changed.

IMPORTANT: Small tables (< 50 rows) are not included in any of this collection’s metrics.

NOTE: While the Delete (MB), Insert (MB), Select (MB), and Update (MB) metrics handle the size in megabytes, the average Select rate, displayed in the chart, can appear in Kb/Sec when the rate values are extremely low.

Frequency Mode	Collection Interval (In Seconds)
Real-time	300
Online	900
Offline	3600

Display Name	Description
Delete (MB)	The cumulative size (in megabytes) of I/O Delete operations performed on indexed and heaped tables in the selected SQL Server instance.
Insert (MB)	The cumulative size (in megabytes) of I/O Insert operations performed on indexed and heaped tables in the selected SQL Server instance.
Select (MB)	The cumulative size (in megabytes) of I/O Select operations performed on indexed and heaped tables in the selected SQL Server instance.
Update (MB)	The cumulative size (in megabytes) of I/O Update operations performed on indexed and heaped tables in the selected SQL Server instance.
Delete (Rows)	The cumulative size, in rows, of I/O Delete operations performed on indexed and heaped tables in the selected SQL Server instance.
Insert (Rows)	The cumulative size, in rows, of I/O Insert operations performed on indexed and heaped tables in the selected SQL Server instance.
Instance	The SQL Server instance name.
Select (Rows)	The cumulative size, in rows, of I/O Select operations performed on indexed and heaped tables in the selected SQL Server instance.
Update (Rows)	The cumulative size, in rows, of I/O Update operations performed on indexed and heaped tables in the selected SQL Server instance.

Frequency Mode	Collection Interval (In Seconds)
Real-time	900
Online	900
Offline	86400

Display Name	Description
Cluster	Indicates if the instance is taking part in a cluster environment.
Collation	The SQL Server instance collation.
Log Shipping	Indicates if Log Shipping is configured.
Mirroring	Indicates if mirroring is configured.
OS Version	The NT version of the computer that runs the SQL Server instance.
Physical Memory	The amount of physical memory on the SQL Server instance host machine.
Process ID	The process ID of the SQL Server instance host machine.
Processor Count	The number of processors on the SQL Server instance’s host machine.
Processor Type	The processor type on the SQL Server instance’s host machine.
Product Version	SQL Server instance product version.
Server Name	The server name of the SQL Server instance.
SP Version	The service pack version of the SQL Server instance.
SQL Edition	The SQL Server instance edition.
SQL Version	SQL Server instance version.
WindowsVersion	The Windows version of the computer that runs the SQL Server instance.

Frequency Mode	Collection Interval (In Seconds)
Real-time	20
Online	60
Offline	300

Display Name	Description
Batch Executions	SQL Batches being submitted to SQL Server for execution.
Batch Executions Rate	The rate per second at which SQL batches are being submitted to SQL Server for execution.
Compiles	Compiling is the process by which SQL Server converts the SQL statement into an executable query plan.
Compiles Rate	The rate per second at which SQL Statements are compiled, that is: converted into an executable query plan.
ReCompiles	A recompile occurs when SQL Server determines that the execution plan for a stored procedure that is currently executing may no longer be the best possible plan.
Redundant Compilations Ratio	Percentage of SQL recompilations that take place. A high percentage of SQL recompilations may indicate the need for additional physical memory. This ratio is calculated as follows: 100 * (Compiles / Compiles + Recompiles)

Frequency Mode	Collection Interval (In Seconds)
Real-time	60
Online	300
Offline	900

Display Name	Description
Creation Date	Indicates the date the SQL statement was first run, thereby allowing the creation of SQL statement statistics
Diff. From Executions	Indicates the incremental difference in the number of SQL executions since the last sample.
Diff. From Total CLR Time	Indicates the incremental difference, since the last sample, in the total CLR time spent for executing the SQL statements.
Diff. From Total CPU	Indicates the incremental difference, since the last sample, in the total CPU time consumed by the SQL executions.
Diff. From Total Elapsed Time	Indicates the incremental difference, since the last sample, in the total time consumed for carrying out the SQL statement.
Diff. From Total I/O	The incremental difference, since the last sample, in the total number of I/O operations that were carried out for executing the SQL statements.
Diff. From Total Logical Reads	The incremental difference, since the last sample, in the total number of logical reads carried out for executing the SQL statements.
Diff. From Total Physical Reads	The incremental difference, since the last sample, in the total number of physical reads carried out upon executing SQL statements.
Diff. From Total Wait Time	The incremental difference, since the last sample, in the total wait time consumed upon executing SQL statements.
Executions	Indicates the number of times the SQL script executed for a unique SQL Handle.
Last Executed	Indicates the last time the SQL statement was executed (last run).
Plan Handle	Provides a unique identification of a SQL statement execution plan.
Query Hash	Query hash value indicates the logic behind a SQL script. Similar SQL queries (that is, SQL queries that differ by literal rather than logical values) have the same query hash value. Therefore, if the execution of such queries results in different query plan hash values, the reason for the difference is most probably the data against which the queries were executed.
SQL Handle	Provides a unique identification of a SQL batch script.
SQL Hit Rate	The percentage of SQL Statements that found the required plan already in the cache. If a matching plan is found, SQL Server does not need to compile the query or the stored procedure. This can save a significant amount of CPU resources, and speed up SQL Server queries.
Statement End Offset	A SQL batch may be combined of multiple SQL statements. While the SQL handle identifies the batch as a whole, this metric provides a unique identification of a specific SQL statement, by indicating the end position of the statement within the SQL batch.
Statement Start Offset	A SQL batch may be combined of multiple SQL statements. While the SQL handle identifies the batch as a whole, this metric provides a unique identification of a specific SQL statement, by indicating the start position of the statement within the SQL batch.
Total CLR Time	The total CLR time spent for executing the SQL statements.
Total CLR Time Per Exec	The average CLR time spent for executing a single CLR execution.
Total CLR Time Rate Top SQL	The total CLR time per second spent for executing the CLR execution.
Total CPU	The total CPU time consumed by the SQL executions.
Total CPU Per Exec	The average CPU time spent for executing a single SQL statement.
Total Elapsed Time	The total time consumed for carrying out the SQL statement executions.
Total Elapsed Time Per Exec	The average time spent for executing a single SQL statement.
Total I/O	The total number of I/O operations that were carried out for executing the SQL statements.
Total I/O per Exec	The average number of I/O operations carried out for executing a single SQL statement.
Total I/O Rate Top SQL	The total number of I/O operations per second that were carried out for executing the SQL statements.
Total Logical Reads	The total number of logical reads carried out for executing the SQL statements.
Total Logical Reads Per Exec	The average number of logical reads carried out for executing a single SQL statements.
Total Logical Reads Rate Top SQL	The total number of logical reads per second that were carried out for executing the SQL statements.
Total Physical Reads	The total number of physical reads carried out for executing the SQL statements.
Total Physical Reads Per Exec	The average number of physical reads carried out per execution of a single SQL statement.
Total Wait Time	The total wait time spent while executing the SQL statements.
Total Wait Time Per Exec	The average time spent on wait events while executing a single SQL statement.

Display Name	Description
SQL Batch	The full text of the SQL execution batch.

Display Name	Description
Query Text	The full text of the SQL statement.

IMPORTANT: If the cache was flushed after the SQL statement was executed, the query plan cannot be retrieved.

Display Name	Description
Query Plan	The full query plan of the SQL statement.

Display Name	Description
Object Name	The name of the object owning the SQL; for example, view, procedure or function. This value can be Unavailable for SQL statements that are not object-owned, such as Ad-Hoc queries.
Query Text	The SQL execution text. The text’s length is configurable, and its default value is 1000 characters.
Is Full Text	Indicates if all the retrieved text can be displayed in the short text field. This metric has a true value only for SQL statements whose text is shorter than the limit defined for short texts.

Display Name	Description
CPU Usage	Time spent by the various sessions consuming CPU cycles. This reading is taken directly from the operating system, rather than SQL Server wait states.
CPU Usage Rate	The average time (seconds) spent by the various sessions consuming CPU cycles.
Executions	Indicates the number of times the SQL script per SQL Handle executed
Total CPU	The total CPU time consumed by the SQL executions
Total Physical Reads	The total number of physical reads carried out for executing the SQL statements
Total Logical Reads	The total number of logical reads carried out for executing the SQL statements
Total Elapsed Time	The total time consumed for carrying out the SQL statement executions
Total CLR Time	The total CLR time spent for executing the SQL statements
Total I/O	The total number of I/O operations that were carried out for executing the SQL statements
Total Wait Time	The total wait time spent while executing the SQL statements
SQL Hit Rate	The percentage of SQL Statements that found the required plan already in the cache. If a matching plan is found, SQL Server does not need to compile the query or the stored procedure. This can save a significant amount of CPU resources, and speed up SQL Server queries.

Display Name	Description
Active Time	Sum of all active wait events; equal to the session total activity within the specified time range.
CLR Wait	Time spent by the various sessions waiting for CLR code execution to complete.
CPU Usage	Time spent by the various sessions consuming CPU cycles. This reading is taken directly from the operating system, rather than SQL Server wait states.
CPU Wait	Time spent by the various sessions waiting in the systems run queue for CPU cycles. This reading is calculated from the operating system readings, rather than SQL Server wait states.
Database	The name of the database where the session is running.
Degree of Parallelism	Average number of SQL Server threads assigned to serve the current SQL statement.
End Time	The time when the selected statement’s execution ended.
Event (list)	The list of wait events for the selected SQL statement.
Event Wait (list)	Time spent on the wait events for the selected SQL statement.
Instance CPU Usage	The amount of CPU time that the SQL Server instance consumed.
IO Wait	Time spent by the various processes waiting for the completion of physical I/O operations.
Latch Wait	Time spent waiting for internal locks (latches) to be released.
Lock Wait	Time spent by the various sessions waiting for a blocking lock (held by another session) to be released.
Log Wait	Time spent waiting by the various processes waiting for a Log operation to complete.
Memory Wait	Time spent by the various sessions waiting for memory resources to be made available.
Network Wait	Time spent by the various sessions waiting for network I/O operations to complete.
Other Wait	Miscellaneous instance waits consisting of infrequent or otherwise special purpose wait states that should, in most cases, be very close to 0.
Physical IO	The total amount of I/O operations carried out so far by the statement.
Remote Provider Wait	The time spent by the various processes waiting for a remote OLEDB call to complete or DTS synchronization.
SPID	The process ID of the blocking session.
SQL Text	The short text of the SQL statement.
Start Time	The time when the SQL statement started.

Frequency Mode	Collection Interval (In Seconds)
Real-time	60
Online	60
Offline	300

Display Name	Description
Availability	Indicates whether the SQL Server instance is available.
Instance Response Time	The full round-trip response time (in milliseconds) of a query representative of general workload (select 1, by default).
Instance Up Since	The SQL Server startup time.
Instance Up Time	The amount of time that the SQL Server instance was running during the current interval. If the instance is down, no data collection occurs. Therefore, if this metric value is less than the interval length, the value of this metric reflects only the active portion of the interval.
Instance Unavailable	The relative amount of time that the SQL Server instance was down during the current interval. If the instance is down, no data collection occurs.
Connection Time	The time when the connection was established.
OS Connect Availability	Indicates whether a connection is available.

Frequency Mode	Collection Interval (In Seconds)
Real-time	300
Online	300
Offline	300

Frequency Mode	Collection Interval (In Seconds)
Real-time	300
Online	300
Offline	300