Database Reference
In-Depth Information
There's more...
For efficient multiserver administration, ensure that SQL Server Agent service is started,
the service account must be a domain account and the account has rights to login as a
target server.
Further, if there are a large number of target servers, then ensure to set up the Multiserver
scheduled jobs on a server that is different from the current production server, because the
target server traffic can affect the performance of the production SQL Server instance.
To configure the appropriate level of security for a specific master server
and target server's communication, set the target server SQL Server Agent
registry subkey \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\
Microsoft SQL Server\< instance_name> \SQLServerAgent\
MsxEncryptChannelOptions(REG_DWORD) to 1 or 2 .
The default value for the SQL Server Agent registry subkey is 2 , which enables the full SSL
encryption and certificate validation between the target server and master server. As a best
practice, unless there is a specific reason, do not attempt to change the value to anything
other than 2 .
See also
For more information on setting up new jobs, refer to the Designing automated administration
practices recipe in Chapter 2 , Administration of the Core Database Engine .
Administrating resource health policies
SQL Server Utility dashboard in SQL Server Management Studio helps monitoring
multiple instances and policies for SQL Server instances and data-tier applications (DAC).
Using the UCP, health policies can be configured for data-tier applications and managed
instances of SQL Server; also, the policies can be defined globally or individually for that
DAC or managed instance.
Many a time, over-utilization and under-utilization of policies for managed instances can be a
long process. File space for storage volumes and database files together with server processor
utilization can be obtained by using UCP resource policies, such as SQL server instance
processor utilization. In this recipe, we will go through the important steps in administering the
resource health policies using Utility Control Point (UCP).
 
Search WWH ::




Custom Search