Tip

Monitoring SQL Server 2008 R2 with SQL Server Management Packs

Shirmattie Seenarine, Contributor
When it comes to monitoring SQL Server 2008 R2, SQL Server Management Packs for System Center Operations Manager 2007 R2 can relieve solutions providers from the laborious task of monitoring the entire SQL Server 2008 R2 infrastructure, which results in more time to focus on other critical day-to-day activities.

    Requires Free Membership to View

More resources on monitoring SQL Server 2008 R2:

Monitoring SQL Server 2008 R2 using SCOM 2007 R2

Resource Governor in SQL Server 2008 R2 manages customers' workloads

New SQL Server 2008 R2 editions, features and licensing

Optimizing SQL Server 2008 performance

Monitoring SQL Server 2008 R2 with SQL Server Management Packs

To begin monitoring SQL Server 2008 R2, solution providers need to install the SQL Server Management Pack for SCOM 2007 R2.

Management Packs (MPs) extend SCOM 2007 R2 management capabilities to operating systems (OSes) and applications. For example, to monitor Exchange, Active Directory, SQL Server, Windows Server 2008 R2 and Windows 7, you can download MPs from Microsoft's website. Microsoft has more than 60 MPs available for free. Or, you can purchase MPs from third-party vendors.

Microsoft's free SQL Server MP monitors the SQL Server infrastructure and databases. Solutions providers should take advantage of the SQL Server MP, because it allows for discovery, monitoring, alerts, reports and tasks.

What the SQL Server Management Pack discovers and monitors

The SQL Server MP for SCOM 2007 R2 supports Enterprise, Standard and Express editions of SQL Server 2008, SQL Server 2005 and SQL Server 2000. It also supports both 32-bit and 64-bit architectures.

Once you install the SQL Server MP, it starts to find SQL Server elements within the SQL Server environment. Monitoring commences soon after. The MP also searches for the following SQL Server components: database engine, analysis services, integration series and reporting services components.

Finally, the MP monitors replication topology, database free space, database fields, SQL Server Agent jobs, database status, health status, log shipping, transaction log free space, locking and blocking. If there's an alert, the operator can be informed in several ways, including through the operations manager console or via email.

About the expert
Shirmattie Seenarine is an independent technical writer with more than 10 years of experience. She has contributed to many books, including Windows Server 2008 Unleashed, Exchange Server 2007 Unleashed, SharePoint Server 2007 Unleashed and SQL Server 2008 Management and Administration. As a technical writer, Shirmattie has written many articles, white papers, design documents and operational procedures for Fortune 500 organizations, including Microsoft, NetApp Inc. and Gilead Sciences Inc. Shirmattie frequently writes articles for TechTarget on various subject matters.


This was first published in March 2010

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.