Databases Reference
In-Depth Information
In addition to using the web console for monitoring, SCA can also be coni gured to send e-mail
notii cations of new SCA alerts.
System Center Operations Manager
The System Center Operations Manager (SCOM) product is Microsoft's enterprise monitoring tool
and part of the Systems Center suite. SCOM provides a powerful, l exible, and highly coni gurable
platform for building a monitoring solution. However, it requires a lot of work. In addition, the
management packs for SQL Server provided by Microsoft have been updated (rather than rewritten)
across several versions of SQL Server. As such, the management packs often use legacy technologies
and don't provide optimal feature coverage for new releases.
The bottom line is that you need to make a signii cant investment in terms of designing, deploy-
ing, coni guring, tuning, and developing in order to create a meaningful monitoring solution with
SCOM.
Design and Implementation
The System Center Operations Manager solution consists of a number of key components (some of
which are shared with the technology used in System Center Advisor), including an Agent, which
must be installed on each server to be monitored; the Gateway, which collects monitoring data; the
Root Management Server (RMS), where the data is stored and aggregated and alerts are generated;
and the Console, which is where DBAs and systems engineers can manage an environment.
Figure 16-12 shows a typical SCOM deployment scenario.
Non-trusted
or remote network
Agents deployed, certificate
authentication
Gateway deployed using
certificate authentication
Non-trusted
or remote network
Monitoring Consoles
Alert Console
Agents
deployed, trusted
authentication
Root Management Server
Monitor Database Cluster
Gateway Server
Active Directory
FIGURE 16-12
Search WWH ::
Custom Search