Page History
...
- View data collected for monitored SQL Server instances
- Modify configuration and view data collected for monitored SQL Server instances
- View data, acknowledge alarms, and control maintenance mode status
- Administrator powers in SQL Diagnostic Manager
| Info |
|---|
You can give access to the Web Application to the specified account, by selecting the Grant Web Application Access option. |
...
SQLDM Area | Cannot do the following |
|---|---|
File Menu | Manage servers |
Tools Menu | Configure default alerts |
Edit notification rules or providers | |
Edit grooming options | |
Help Menu | Manage licenses |
Servers pane | Delete servers |
Enter or exit Maintenance Mode | |
Configure alerts, but can view alert settings | |
Edit SQL Server properties, but can view properties | |
Today Page > Active Alerts | Configure alerts, but can view alerts |
Today Page > Common Tasks | Manage servers |
Mini-Monitors grid | Delete mini-monitors |
Edit properties, but can view properties | |
Server Overview > Dashboard | Enter or exit Maintenance Mode |
Configure alerts, but can view alert settings | |
Server Overview > Details | Configure alerts, but can view alert settings |
Server Overview > Configuration | Edit value |
Session > Details | Trace or kill a session |
Session > Locks | Trace or kill a session |
Session > Blocking | Trace or kill a session |
Queries/Non-query activities | Configure Query/Activity Monitor properties, but can view properties |
Resources > Procedure Cache | Clear cache |
Databases > Tables and Indexes | Update statistics or rebuild indexes |
Services > Summary | Start or stop services |
Services > SQL Agent Jobs | Start or stop job |
Logs | Cycle server log |
Configure | |
Alerts pane | Configure default alerts |
Edit notification rules and providers | |
Alerts > Grid | Configure alerts, but can view alerts |
Clear alerts | |
Clear alerts of this type for this instance | |
Administration pane | Access or view Administration |
...