Book Image

Getting Started with Microsoft System Center Operations Manager

By : Kevin Greene
Book Image

Getting Started with Microsoft System Center Operations Manager

By: Kevin Greene

Overview of this book

Most modern IT environments comprise a heterogeneous mixture of servers, network devices, virtual hypervisors, storage solutions, cross-platform operating systems and applications. All this complexity brings a requirement to deliver a centralized monitoring and reporting solution that can help IT administrators quickly identify where the problems are and how best to resolve them. Using System Center Operations Manager (OpsMgr), administrators get a full monitoring overview of the IT services they have responsibility for across the organization - along with some useful management capabilities to help them remediate any issues they've been alerted to. This book begins with an introduction to OpsMgr and its core concepts and then walks you through designing and deploying the various roles. After a chapter on exploring the consoles, you will learn how to deploy agents, work with management packs, configure network monitoring and model your IT services using distributed applications. There’s a chapter dedicated to alert tuning and another that demonstrates how to visualize your IT using dashboards. The final chapters in the book discuss how to create alert subscriptions, manage reports, backup and recover OpsMgr, perform maintenance and troubleshoot common problems.
Table of Contents (18 chapters)
Getting Started with Microsoft System Center Operations Manager
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Using SQL queries for maintenance


One of the most visited blog posts related to OpsMgr on the internet has to be Kevin Holman's 'Useful Operations Manager SQL Queries' post - http://tinyurl.com/kholmansqlqueries. Originally written for OpsMgr 2007 but still fully relevant for later releases, this blog post contains a goldmine of SQL queries that you can use to carry out maintenance and troubleshooting tasks in your environment.

Over the years, I've probably used every one of those SQL queries but these are the ones I tend to re-use on a regular basis:

  • Large table query

  • Top 20 alerts in an Operational database, by repeat count

  • Top 20 performance insertions by perf object and counter name

  • State changes per day

  • Noisiest monitors changing state in the database in the last 7 days

  • Find the rules collecting the most performance signature data in the database

  • Find all groups for a given computer/object

  • Set an individual agent back to Remotely Manageable

  • Find a computer name from a Health Service ID

Make sure...