Utility Administration (SQL Server Utility)

  • Article

Use the Utility Administration tabs to manage policy, security, and data warehouse settings for a SQL Server Utility. For more information about SQL Server Utility concepts, see SQL Server Utility Features and Tasks.

Policy tab - Use the policy tab to view or specify global monitoring policies.

  • Set global data-tier application monitoring policies. To expand the list of values for this option, click on the arrow next to the policy name, or click on the policy title.
    When is an application running out of processor capacity? To change this policy, use the control to the right of the policy description, then click Apply. You can also restore default values or discard changes using buttons at the bottom of the display.

    • The default maximum value for processor utilization is 70%.

    • The default minimum value for processor utilization is 0%.

    When is an application running out of file space? To change the policy for data file or log file space utilization, use the control to the right of the policy description, then click Apply. You can also restore default values or discard changes using buttons at the bottom of the display.

    • The default maximum value for file space utilization is 70%.

    • The default minimum value for file space utilization is 0%.

  • Set global SQL Server managed instance application monitoring policies. To expand the list of values for this option, click on the arrow next to the policy name, or click on the policy title.
    When is a managed instance of SQL Server running out of processor capacity? To change this policy, use the control to the right of the policy description, then click Apply. You can also restore default values or discard changes using buttons at the bottom of the display.

    • The default maximum value for instance processor utilization is 70%.

    • The default minimum value for instance processor utilization is 0%.

    When is a managed instance of SQL Server computer running out of processor capacity? To change this policy, use the control to the right of the policy description, then click Apply. You can also restore default values or discard changes using buttons at the bottom of the display.

    • The default maximum value for computer processor utilization is 70%.

    • The default minimum value for computer processor utilization is 0%.

    When is a managed instance of SQL Server running out of file space? To change the policy for data file or log file space utilization , use the control to the right of the policy description, then click Apply. You can also restore default values or discard changes using buttons at the bottom of the display.

    • The default maximum value for file space utilization is 70%.

    • The default minimum value for file space utilization is 0%.

    When is a managed instance of SQL Server computer running out of storage volume space? To change this policy, use the control to the right of the policy description, then click Apply. You can also restore default values or discard changes using buttons at the bottom of the display.

    • The default maximum value for computer volume space utilization is 70%.

    • The default minimum value for computer volume space utilization is 0%.

  • Reducing policy violation noise from highly volatile resources. To expand the controls for this feature, click on the down-arrow on the right side of the display.
    For more information, see Reduce Noise in CPU Utilization Policies (SQL Server Utility)

Security tab - Displays login names with permissions to administer or read from the UCP.

  • Select the logins from the UCP that will be added to the Utility Reader role.
    The Utility Reader privilege allows the user account to:

    • Connect to the SQL Server Utility.

    • See all viewpoints in the Utility Explorer in SSMS.

    • See settings on the Utility Administration node in Utility Explorer in SSMS.

Utility administrators can enroll instances of SQL Server into and remove instances of SQL Server from a SQL Server Utility, as well as modify policies on managed instances and modify administration settings on the UCP.

To be a Utility administrator, you must have sysadmin privileges on the instance of SQL Server. To add or change user accounts for the SQL Server UCP, use Object Explorer in SSMS to add the user to the server logins of the UCP instance of SQL Server. For more information, see sp_addlogin (Transact-SQL).

Data Warehouse tab - Displays configuration details for the utility management data warehouse.

  • Data Retention
    Specify the data retention period for utilization information collected for managed instances of SQL Server. The default time period is 1 year. The minimum value is 1 month. The longest supported value is 2 years.

  • Utility Data Warehouse Configuration Information
    The following configuration settings are not configurable in this release of SQL Server:

    • UMDW name: Sysutility_mdw_<GUID>_DATA.

    • Collection set upload frequency: Every 15 minutes.

    The UMDW directory is configurable: <System drive>:\Program Files\Microsoft SQL Server\MSSQL10_50.<UCP_Name>\MSSQL\Data\, where <System drive> is normally the C:\ drive. The log file, UMDW_<GUID>_LOG, is located in the same directory.

    Note

    The UMDW (sysutility_mdw) file location can be changed using detach/attach or ALTER DATABASE. We recommend the use of ALTER DATABASE. For more information, see ALTER DATABASE (Transact-SQL).

  • Go back to out-of-the-box defaults
    To reset settings on this tab to default values, click the Restore Defaults button, then click Apply.

See Also

Reference

Utility Dashboard (SQL Server Utility)

Deployed Data-tier Application Details (SQL Server Utility)

Managed Instance Details (SQL Server Utility)

Other Resources

Monitor Instances of SQL Server in the SQL Server Utility