Page History
...
- Associate tags with an instance
- Select a diagnostic data collection interval
- Select a server availability verification interval
- Assign a friendly name to your SQL Server instance
- Collect extended session data
- Assign data collection credentials
- Select encryption options
...
You can access the General tab of the Monitor SQL Server Properties window by right-clicking the appropriate monitored SQL Server instance, and then selecting Properties.
AnchorGPtags GPtags
Associate tags with an instance
GPtags | |
GPtags |
...
The interval between times that the SQLDM Collection Service collects diagnostic data and raises the associated alerts. Lower values cause SQL Diagnostic Manager to raise alerts more quickly, but also cause more frequent refreshes, which increases your monitoring overhead.
Alert if the server is inaccessible (max 10 minutes)
The server availability verification interval is the amount of time SQL Diagnostic Manager waits between verifying availability on the selected SQL Server instance. If the connection test collector does not complete within the time specified in the Alert if the server is inaccessible (max 10 minutes) field, the SQL Server instance is considered unresponsive. Setting this field to a very low value can result in false positive alerts.
Collect and alert on database metrics (max 24 hours)
...
SQL Diagnostic Manager averages most metrics over the timeframe between collections. More-frequent data collection causes increased movement in averages because of short-duration events. For example, a 15-second CPU spike has a greater effect on a one-minute refresh than on a six-minute refresh. You can use alert smoothing to reduce the impact of data spikes on a per-alert basis.
...
.
AnchorGPfriendly GPfriendly
Assign a friendly name to your SQL Server instance
GPfriendly | |
GPfriendly |
...
Scroll pdf ignore |
---|
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > > |