Monday, January 18, 2016

What is SQL Server Utility?

It is an utility that helps comparing your SQL Server Performance to Policies and help identifying problems, if any.

SQL Server Utility also goes by the name SQL Server Utility Control Point and it collects configuration and performance information from managed instances of SQL Server every 15 minutes. This information is stored in the Utility Management Data Warehouse(UMDW) on the UCP with the file name sysutility_mdw. SQL Server performance is compared with the established policies and problems are flagged.

If you have multiple SQL Server Instances or data-tier applications consider creating a SQL Server Utility Control Point (UCP).

No comments: