Page History
In this window you can specify the SQLDM permissions you want to assign to the login. You can apply the following permissions to the specified account:
- 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. |
...
View Permissions
Logins with View permissions can view the data collected for the assigned SQL Server instances except where noted in the following table.
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 |
Modify Permissions
Logins with Modify permissions can edit basic settings for the data collected for assigned SQL Server instances except where noted in the following table.
SQLDM Area | Cannot do the following |
|---|---|
File Menu | Manage servers |
Tools Menu |
Edit alert configuration | |
Edit notification rules or providers | |
Edit grooming options | |
Help Menu | Manage licenses |
Alerts pane |
Configure default alerts | |
Edit notification rules or providers | |
Administration pane | Access or view Administration |
Administration Permissions
...
| Scroll pdf ignore |
|---|
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > > |