Solved

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

Posted on 2012-03-20
1
258 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 14

Accepted Solution

by:
alimu earned 500 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

717 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