Specifications
The SQL Server Utility CHAPTER 2 25
UCP Prerequisites
As with other SQL Server components and features, the deployment of a SQL Server UCP
must meet the following specic prerequisites and requirements:
■
The SQL Server version running the UCP must be SQL Server 2008 R2 or higher. (SQL
Server 2008 R2 is also referred to as version 10.5.)
■
The SQL Server 2008 R2 edition must be Datacenter, Enterprise, Evaluation, or
Developer.
■
The SQL Server system running the UCP must reside within a Windows Active Directory
domain.
■
The underlying operating system must be Windows Server 2003, Windows Server
2008, or Windows Server 2008 R2. If Windows Server 2003 is used, the SQL Server
Agent service account must be a member of the Performance Monitor User group.
■
It is recommended that the collation settings afliated with the Database Engine in-
stance hosting the UCP be case-insensitive.
NOTE The Database Engine instance is the only component that can be managed
by a UCP. Other components, such as Analysis Services and Reporting Services, are not
supported.
After all these prerequisites are met, you can deploy the UCP. However, before installing
the UCP, it is benecial to size the UMDW accordingly and understand the maximum capacity
specications associated with a UCP.
UCP Sizing and Maximum Capacity Specications
The wealth of information captured during capacity planning sessions can help an organiza-
tion better understand its environment and make informed decisions when designing the
UCP implementation. In the case of the SQL Server Utility, it is helpful to know that each
SQL Server UCP can manage and monitor up to 100 computers and up to 200 SQL Server
Database Engine instances. Both computers and instances can be either physical or virtual.
Additional UCPs should be provisioned if there is a need to monitor more computers and
instances.
Disk space consumption is another area you should look at in capacity planning. For
instance, the disk space consumed within the UMDW is approximately 2 GB of data per year
for each managed instance of SQL Server , whereas the disk space used by the msdb database
on the UCP instance is approximately 20 MB per managed instance of SQL Server. Last, a SQL
Server UCP can support up to a total of 1,000 user databases.