Date: Thu, 28 Mar 2024 19:11:52 +0000 (UTC) Message-ID: <773352983.68867.1711653112817@ip-10-0-1-26.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_68866_2045254911.1711653112816" ------=_Part_68866_2045254911.1711653112816 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
The Dashboard view contains a gra= phical representation of the activity on your SQL Server instance. Thi= s view not only displays the status of your SQL Server instance, but i= t allows you to diagnose where problems originate.
The Dashboard view is made up of panels, =
which include additional information for specific metrics in chart f=
orm. Hover your mouse cursor over an area within a chart on which you w=
ant to get actual statistics. Click a specific metric to drill down for mor=
e detailed information. By using the options in the menu available when you=
right-click over an area, you can configure alerts, view associated help t=
opics and details, print, save the image, or export the dashboard to Micros=
oft Excel as a .csv
file.
You can also customize your Dashboard vie= w to show only those panels that are important to your monitored SQL S= erver instance. SQL Diagnostic Manager also allows you to save your customi= zed view on a per-instance basis or use the same view for all of your insta= nces. For more information about customizing your Dashboard view, see Customize your Dashboard view.
You can open the Dashboard view of the SQ= L Diagnostic Manager Overview tab by selecting the appropriate SQL Ser= ver instance, and then clicking Overview > Dashboard .
The Dashboard view is organized with panels that display all the key met= rics collected by SQL Diagnostic Manager by category.
The available data panels for the Dashboard view include:
The Cache panel tracks the databas= e and procedure processes using a buffer pool of memory on your monitored S= QL Server instance, and includes the following charts and gauges:
The CPU panel includes key CPU met= rics for your SQL Server instance and the computer that hosts the instance.= The metrics displayed in CPU include the following charts and gauges:
&nb= sp;The Custom Counters panel tracks selected custom count= ers for your monitored SQL Server instance. You must have at least one= custom counter to view data in this panel.
The Databases panel includes key m= etrics covering the health of the databases on your monitored SQL Server in= stance. The metrics displayed in Databases include the following charts and= gauges:
The Disk panel= includes key metrics that monitor the health of the disk of your monit= ored SQL Server instance. The metrics displayed in Disk include the followi= ng charts and gauges:
The File Activ= ity panel includes the top five database files with the highest relativ= e activity since the last refresh of your monitored SQL Server instanc= e. You can select different metrics and display results for all files, or a= single database, disk, or file. The available metrics include:
&nb= sp;The Lock Waits panel tracks the total number waits cau= sed when a task is waiting to acquire a lock on your monitored SQL Server.<= /p>
The Memory panel includes key Memo= ry metrics for your SQL Server instance and the computer that hosts the ins= tance. The metrics displayed in Memory include the following charts:
The Network panel tracks the perfo= rmance of the network connection being used by your monitored SQL Server, a= nd includes the following charts and gauge:
The Server Waits panel tracks the =
total number and time spent on waits affecting your monitored SQL Server.
The Sessions panel includes sessio= n-specific data items. The metrics displayed in Sessions include the follow= ing chart and gauge:
The Tempdb panel tracks the status of the= tempdb database on your monitored SQL Server instance, and includes the fo= llowing charts and gauge:
The Virtualiza= tion panel tracks the performance of the host server that manages your = virtual machines and the VM on which the monitored SQL Server ins= tance is running, and includes the following charts and gauge:
The following colo=
rs are associated with a status for each of the provided panels.
&nb= sp;Indicates the status of the data is normal, or within the thresho= lds assigned to the metric.
&nb= sp;Indicates the status of the data is at an informational level bas= ed on your settings.
Indicates the status of the data is at a = warning level, or outside the threshold of normal but not yet at the critic= al status.
Indicates the status of the data is at a = critical level and requires immediate action.
If a metric on the Dashboard has no value= , or displays as blank, SQL Diagnostic Manager is not able to collect the c= orresponding counter. Causes of this situation include:
You can enable OS metrics monitoring to track the performance= of the computers on which your monitored SQL Server instances are hosted.<= /p>
The Dashboard view is refreshed according to the time set in the Server View Refresh f= ield on the Console Options window, which is accessible by clicking Tools > Console Options.
SQL Diagnostic Manager charts provide dat= a whether collected real-time or as part of a scheduled collection event. F= or additional information about how SQL Diagnostic Manager displays your ch= art data, see Charts.