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

Tips for deploying SQL


Before you can install OpsMgr, you need to deploy a SQL environment to host the databases. A full installation of SQL is relatively straight-forward and you can refer to http://tinyurl.com/sqlinstall for a step-by-step walkthrough of SQL 2014 (the steps in this link are also applicable for SQL 2012 R2 and SQL 2016).

There are however, a few pointers that you need to take into account when deploying SQL with OpsMgr and this section will help you avoid some of the common pitfalls that people encounter.

SQL features and collation setting

During the installation of SQL, you will be asked to choose the features that you want installed into your new instance. A database requirement of OpsMgr is that the Full-Text and Semantic Extractions for Search feature shown in Figure 2.5 is selected and this is something that a lot of people miss when deploying OpsMgr for the first time.

Figure 2.5: Choosing the Full Text Search feature

Tip

When selecting features for a new SQL instance,...