Database Reference
In-Depth Information
How it works...
SQL Server Utility is instrumented to manage instances that are registered with a data
collection set, which sends configuration and performance data to UCP every 15 minutes.
DAC applications are automatically managed by UCP, if they belong to a managed instance.
UCP also supports other monitoring parameters such as database file space utilization, CPU
utilization, and storage volume utilization.
Health policies can be defined globally for all data-tier applications and managed instances
of SQL Server in the SQL Server Utility, or they can be defined individually for each data-tier
application and for each managed instance of SQL Server in the SQL Server Utility.
Using SQL Server 2008 R2 SSMS tool, an SQL Server 2008 instance can be enrolled with a UCP.
The evaluation time period and tolerance for percent violations are both configurable using
the Policy tab settings in the Utility Administration node of Utility Explorer. You can also
restore default values or discard changes using buttons at the bottom of the display.
The summary and detailed data is presented in Management Studio for each instance of
SQL Server and data-tier application, SQL Server Utility dashboard in SSMS presents an at-a-
glance summary of performance and configuration data for managed instance and data-tier
application CPU utilization, database file utilization, storage volume utilization, and computer
CPU utilization. Data displays provide separation of over-utilized and under-utilized resources,
as well as graphs of CPU utilization and storage utilization over time. Each instance of SQL
Server and data-tier application managed by the SQL Server Utility can be monitored based on
global policy definitions, or based on individual policy definitions.
Administering SQL Server Replication
processes
Replication is the oldest data distribution technique within RDBMS and has been supported
by SQL Server since version 6.5. Replication's main purpose is to copy data from one server to
another, which is used as a marginal high availability feature for certain types of applications.
Replication agents are the key handlers that carry out all the tasks associated with
replication, which includes creating a snapshot of schema and data, detecting updates,
detecting conflict updates, and propagating changes between servers. All the replication
agents are run under SQL Server agent job steps and these executables can be called directly
from a batch script, or command-line operation. Replication provides a default profile for
each agent and additional pre-defined profiles for the log reader agent, distributor agent, and
merge agent. The agent profile contains a set of parameters that are used each time an agent
runs at the Distributor server instance.
Search WWH ::
Custom Search