Page History
...
Logins with View permissions can view the data collected for the assigned SQL Server instances except where noted in the following table.
SQLdm 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 |
...