Select the type of permissions to grant to the specified account. When you add login permissions to SQLdm, you have the following permission choices:
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
Logins with Administration permissions can access all monitored SQL Server instances and modify all settings including grooming options, notification rules and providers, manage SQLdm licenses, manage application security including the ability to add custom counters, and has the ability to add and remove SQL Server instances in SQLdm.
You cannot edit or delete logins belonging to the sysadmin role on the SQLdm Repository as they have SQLdm Administrator privileges.
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >