Performance Monitor Data Views
The Teratrax database contains predefined views that expose the
performance information collected to users and other programs. These
views provide a comprehensive way for retrieving performance data
without having to understand the Teratrax Performance Monitor table
structure. Teratrax recommends the use of these views instead of
querying the tables directly. Teratrax will support these views in
future releases even if the underlying tables were changed. The
following is a list of the Teratrax Performance Monitor views:
SQL_Server_Information
The SQL Server Instance report contains information about the
monitored instance of SQL Server. Monitored_From contains the name of
the computer where Teratrax Monitoring Services is running.
System_Utilization_Hourly
The System Utilization Hourly Aggregation report contains information
about performance counters, users, open transactions, and login
attempts. CPU, Memory, and IO figures represent the percentages of
utilization averaged hourly. Reads and Writes figures represent total
non-cached disk operations.
System_Utilization_Daily
The System Utilization Daily Aggregation report contains information
about performance counters, users, open transactions, and login
attempts. CPU, Memory, and IO figures represent the percentages of
utilization averaged daily. Reads and Writes figures represent total
non-cached disk operations.
SQL_Server_Blocking
The SQL Server Blocking report contains information about concurrency
and SQL Server process blocking. Duration figures are in milliseconds.
SQL_Server_Blocking_Stat_Hourly
The SQL Server Blocking Hourly Statistics report contains information
about SQL Server blocking aggregated hourly. Duration figures are in
milliseconds.
SQL_Server_Blocking_Stat_Daily
The SQL Server Blocking Daily Statistics report contains information
about SQL Server blocking aggregated daily. Duration figures are in
milliseconds.
Slow_Failed_Jobs
The Slow and Failed Jobs report contains information about SQL Agent
jobs that are performing poorly. Duration figures are in seconds.
Slow_Failed_Jobs_Stat_Hourly
The Slow and Failed Jobs Hourly Statistics report contains
information about poorly performing SQL Agent jobs aggregated hourly.
Duration figures are in seconds.
Slow_Failed_Jobs_Stat_Daily
The Slow and Failed Jobs Daily Statistics report contains information
about poorly performing SQL Agent jobs aggregated daily. Duration
figures are in seconds.
Slow_SQL_Code
The Slow SQL Code report contains information about poorly performing
SQL batches and stored procedures. Duration
figures are in milliseconds.
Slow_SQL_Code_Stats_Hourly
The Slow SQL Code Hourly Statistics report contains information about
poorly performing SQL batches and stored procedures aggregated hourly. Duration figures are in milliseconds.
Slow_SQL_Code_Stats_Daily
The Slow SQL Code Daily Statistics report contains information about
poorly performing SQL batches and stored procedures aggregated daily. Duration figures are in milliseconds.
|
