System monitoring or tooling for SQL

System monitoring or tooling for SQL

•SQL Server Pro-filer
•System monitoring / Perform/ PAL tool
•Activity Monitor (SQL Server Management Studio)
•Event logs, SQL logs
•Dynamic Management Views (DMVs) / standard reports
•SQL trace (sp_traceTSQL)
•System Stored Procedures (sp_who, sp_lock…)
•DBCC statements
•Built-in functions (@@CPU_BUSY, @@CONNECTIONS…)
•Trace Flags
•Database Engine Tuning Advisers


Comments