This article provides an overview of SQL Server monitoring tools and techniques, including SQL Server Profiler, SQL Server Extended Events, SQL Server Management Studio Reports, SQL Server Management Studio Activity Monitor, dynamic management views and functions, Windows Resources Monitor, and third-party tools. It explains the importance of database monitoring and highlights the availability of free and commercial tools for SQL Server monitoring.
Table of contents
Database monitoring: a quick reminderSQL Server ProfilerSQL Server Extended EventsSQL Server Management Studio ReportsSQL Server Management Studio Activity MonitorDynamic management views and functionsWindows Resources MonitorThird-Party ToolsSummary45 Impressions