Performance Views
The TPM40 database on the monitored SQL Server instance contains predefined
SQL views that expose collected
performance information to users and other programs. These
performance
views provide a comprehensive way for retrieving performance data
without having to understand the table
structure of the database. Teratrax recommends the use of these views
instead of querying the tables directly. You can issue queries against
these views with a WHERE clause to filter information as needed.
SQL_Server_Information
This view contains details about the
monitored instance of SQL Server.
System_Utilization_Hourly
This view reports aggregated information
about performance counters on an hourly basis. CPU, Memory, Cache_Hit_Ratio, and Proc_Cache_Hit_Ratio figures represent the
average percentages of utilization. Reads and Writes represent total
non-cached disk operations.
System_Utilization_Daily
This view reports aggregated information
about performance counters on a daily basis. CPU, Memory, Cache_Hit_Ratio, and Proc_Cache_Hit_Ratio figures represent the
average percentages of utilization. Reads and Writes represent total
non-cached disk operations.
Slow_SQL_Code
This view contains information about slow
SQL batches (including stored procedures) and RPC events. Duration
and CPU_Time are in milliseconds. The Disk_Reads column represents
logical reads (Pages read from cache). The Disk_Writes column represents
physical writes (Pages written to disk).
Slow_SQL_Code_Stats_Hourly
This view contains hourly statistics about slow
SQL batches (including stored procedures) and RPC events. Min_Duration,
Avg_Duration, Max_Duration, and Avg_CPU_Time are in milliseconds. The
Avg_Disk_Reads column represents logical reads (Pages read from cache).
The Avg_Disk_Writes column represents physical writes (Pages written to
disk).
Slow_SQL_Code_Stats_Daily
This view contains daily statistics about slow
SQL batches (including stored procedures) and RPC events. Min_Duration,
Avg_Duration, Max_Duration, and Avg_CPU_Time are in milliseconds. The
Avg_Disk_Reads column represents logical reads (Pages read from cache).
The Avg_Disk_Writes column represents physical writes (Pages written to
disk).
SQL_Server_Blocking
This view contains information about concurrency
and SQL Server process blocking. Duration is in milliseconds.
SQL_Server_Blocking_Stat_Hourly
This view contains hourly statistics about SQL Server process blocking. Duration figures are in milliseconds.
SQL_Server_Blocking_Stat_Daily
This view contains daily statistics about SQL Server process blocking. Duration figures are in milliseconds.
Deadlocks
This view contains information about SQL Server deadlocks.
Deadlocks_Stat_Hourly
This view contains hourly statistics about SQL Server deadlocks.
Deadlocks_Stat_Daily
This view contains daily statistics about SQL Server deadlocks.
Slow_Failed_Jobs
This view contains information about SQL Agent
jobs that are performing poorly. Duration figures are in seconds.
Slow_Failed_Jobs_Stat_Hourly
This view contains hourly statistics about SQL Agent
jobs that are performing poorly. Duration figures are in seconds.
Slow_Failed_Jobs_Stat_Daily
This view contains daily statistics about SQL Agent
jobs that are performing poorly. Duration figures are in seconds.
Failed_Logins
This view contains information about failed login attempts.
Failed_Logins_Stat_Hourly
This view contains hourly statistics about failed login attempts.
Failed_Logins_Stat_Daily
This view contains daily statistics about failed login attempts. |
