Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2012-03-20
1
Medium Priority
?
262 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 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

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

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

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 article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

618 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