Bài giảng Cơ sở dữ liệu nâng cao - Chapter 8: Monitoring SQL server. Chương này trình bày một số nội dung: The goal of monitoring, performance monitor, dynamic management views, monitoring events, event notifications,. | Monitoring SQL Server The Goal of Monitoring The goal of monitoring databases is to see: What’s going on inside SQL Server, How effectively SQL Server is using the server resources (CPU, Memory, I/O). The information enables DBA identify abnormal activities The Goal of Monitoring Once you define your monitoring goals you should select the appropriate tools for monitoring. The following list describes basic monitoring tools to view the current activities: Performance Monitor: a useful tool that tracks resource use on Microsoft operating systems. It can monitor resource usage for the server and provide information specific to SQL Server either locally or for a remote server SQL Profiler: a graphical application that enables you to capture a trace of events that occurred in SQL Server. The Goal of Monitoring The following list describes the basic monitoring tools: SQL Trace: the T-SQL stored procedure way to invoke a SQL Server trace without having to start up the SQL Profiler application. It requires a little more work to set up, but it’s a lightweight way to capture a trace It’s scriptable enables the automation of trace capture Default trace: a light weight trace that runs in a continuous loop and captures a small set of key database and server events. useful in diagnosing events that may have occurred when no other monitoring was in place. The Goal of Monitoring The following list describes the basic monitoring tools: Activity Monitor: a tool graphically displays the following information: Processes running on an instance of SQL Server Locks User activity Blocked processes Dynamic management views: return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance. Transact-SQL: Some system stored procedures provide useful information for SQL Server monitoring, such as sp_who,sp_who2,sp_lock, and several others. Performance Monitor Performance Monitor is an important tool because it enables to . | Monitoring SQL Server The Goal of Monitoring The goal of monitoring databases is to see: What’s going on inside SQL Server, How effectively SQL Server is using the server resources (CPU, Memory, I/O). The information enables DBA identify abnormal activities The Goal of Monitoring Once you define your monitoring goals you should select the appropriate tools for monitoring. The following list describes basic monitoring tools to view the current activities: Performance Monitor: a useful tool that tracks resource use on Microsoft operating systems. It can monitor resource usage for the server and provide information specific to SQL Server either locally or for a remote server SQL Profiler: a graphical application that enables you to capture a trace of events that occurred in SQL Server. The Goal of Monitoring The following list describes the basic monitoring tools: SQL Trace: the T-SQL stored procedure way to invoke a SQL Server trace without having to start up the SQL Profiler .
