[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2012-03-20
1
Medium Priority
?
264 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 2000 total points
ID: 37786508
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Screencast - Getting to Know the Pipeline

873 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