Software Applications Programming Errors and solutions.

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