Date: Fri, 29 Mar 2024 07:10:55 +0000 (UTC) Message-ID: <639964527.69701.1711696255264@ip-10-0-1-26.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_69700_521625611.1711696255257" ------=_Part_69700_521625611.1711696255257 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
The Monitored SQL Server Properties window allows you to edit the SQ= L Diagnostic Manager monitoring settings for the registered SQL Server= instance. To access the Monitored SQL Server Properties window, right= -click a SQL Server instance from the Server tree and= select Properties.
The Monitored SQL Server Propert= ies window includes the following tabs:
Displa= ys common properties such as the data collection interval, credentials, and= encryption options.
Allows= you to set the date range and time used to calculate a performance baselin= e for the monitored SQL Server instance.
Allows= you to enable or disable query monitoring, and set the options for the Query Monitor.
Allows= you to enable or disable monitoring of non-query activities, and set the o= ptions for the Activity Monitor.
Lets y= ou disable replication statistics collection to conserve system resources.<= /span>
Allows= you to select the time and days SQL Diagnostic Manager collects table stat= istics on your SQL Server instance. In addition, you can select the mi= nimum size table needed for SQL Diagnostic Manager to rebuild the index.
Allows= you to link custom counters to the monitored SQL Server instance<= /a>.
Allows= you to enter the maintenance schedule for your server. This allows you to = turn off alerts and notifications for the time periods when you know the se= rver is unavailable.
Allows= you to select how you want your operating system data collected, whether t= hrough OLE automation or direct WMI. You can also choose to not collec= t OS data.
Allows= SQL Diagnostic Manager to alert on disk drives and database space calculat= ions for the monitored SQL Server instance.
Lets S= QL Diagnostic Manager trigger an alert whenever a cluster is running on a n= on-preferred node within a clustered environment.
Allows= you to collect and view wait statistics in the hopes of diagnosing any bot= tleneck on your system.
Displa= ys the name of the host server on which the selected monitored SQL Server i= nstance is running.
Allows= you to schedule a prescriptive analysis of your monitored SQL Server = instance.
=
span>