|
|
TbDbMonitor 2003
Features
- Track all queries, batches and stored procedures (with parameters)
that are executed on SQL Server
- Gathers information about amount of disk (IO) and CPU (compilation
time, execution time) activity generated by Transact-SQL statements
- Collects all SQL Server errors
Usage scenarios
The system can be used in following scenarios:
- To identify slowest stored procedures
- To identify frequency of usage of individual stored procedures
- To determine if defects are result of application or database
problems
- To compare current and historic performance of complete systems and
individual queries
Components
- TbDbMonitor Data Warehouse – stores historic information
all queries that are executed on the server
- TbDbMonitor Cubes – aggregation of historic data
- TbDbMonitor Explorer – Windows application for reviewing
gathered information
Requirements
Data Warehouse Server
Windows Application
|
