Solved

How to install & configure System Center Operations Manager for SQL server 2008?

Posted on 2012-03-20
1
253 Views
Last Modified: 2012-06-21
Hi,
I wish to install SCOM to monitor my sql server 2008 databases.

http://www.microsoft.com/en-us/server-cloud/system-center/operations-manager-overview.aspx

1. Do I need SQL database to install SCOM?
2. Is there an agent which I need to deploy at each SQL server database?
3. How to configure reports

Thanks
0
Comment
Question by:crazywolf2010
1 Comment
 
LVL 14

Accepted Solution

by:
alimu earned 500 total points
Comment Utility
1. Yes, you need a management server, two databases for SCOM if you wish to use reporting - the Operational Database and the Data Warehouse Database, and a dedicated  sql reporting server (i.e. reporting services not used for anything else) to run SCOM with reporting functionality. All of these roles may exist on the same system but I would review the design guide before planning your configuration.

2. You install one agent on each physical SQL server.  

3. The reports are installed as part of management pack installation (automatically deployed) as long as the pre-requisite Data Warehouse and Reporting Server components are already installed.

Perhaps take a look at the information on SCOM 2007R2 available on technet library which will walk you designing a SCOM installation and installing it here: http://technet.microsoft.com/en-us/library/dd789005.aspx

To monitor SQL server and databases you would need to install the SQL management pack.  There is a comprehensive installation guide that ships with the management pack and steps you through getting it working. The technet version of the same documentation is here: http://technet.microsoft.com/en-us/library/dd767418.aspx

I hope this helps you on your journey.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This video discusses moving either the default database or any database to a new volume.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now