Solved

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

Posted on 2012-03-20
1
257 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

Suggested Solutions

Title # Comments Views Activity
sql 2014,  lock limit 5 46
SQL Insert parts by customer 12 53
Are triggers slow? 7 25
SQL Server remove line breaks and tabbed 2 8
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

726 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