IT Operations Management (ITOM)

A new SQL to the IT Operations Management cockpit story

A new SQL to the IT Operations Management cockpit story


Article written by
Manoj Mohanan

Technical Ambassador

HP Operations Management Packs and Content Packs


Everyone experiences this phenomenon—we all have so much to do that things are pushed lower and lower on the list, right?


It is no surprise that when new business services are rolled out, it is often a second or third priority to deal with the requirements to manage the components they depend on. They are even overlooked occasionally.  This happens more frequently than you think. In this situation, some business applications are running, revenue is being generated but there is not a pilot at the helm and there is minimal control, invariably leading to panic circumstances when things fall.

This story might paint an extreme picture, (maybe in your environment things akin to this aren’t as disastrous) but how much of your business services are 100 percent covered by IT Operations?


Do you throw monitoring tools too widely and hope you’ve got everything covered?

In this day and age, applications on our modern devices, smartphones, tablets etc. are almost self managed. There should be a way to automate IT monitoring, so that all best practices are systematically applied to every instance of IT components as they are deployed to support business initiatives.


There is and it’s an HPBSM capability within HP  Operations Manager i-series and it is called Monitoring Automation. Already applied to Hadoop, Vertica, Infrastructure and ORACLE environments, the same features are now available in Management Pack software for Microsoft SQL Server. Updates are also available for the existing ORACLE and Infrastructure packs.


You can download Operations Manger i here to experience it in your environment


How much time does your IT Operations staff spend handling requests to change monitoring parameters?


This Monitoring Automation provides self-service capabilities, which allows IT to give access to subject matter experts and line of business staff that know what characteristics of monitoring they want to implement.This includes thresholds, frequencies etc. to trigger alerts to operations, but do want, nor need to know about, the underlying monitoring tools, how they operate, how to configure them and so on.


Standard tools such as Sitescope, Operations Manager agents and more later are directly configured by HP OMi Monitoring Automation—which hides tehcnical details to simplify operations management.


The new MS SQL Server Management Pack has the following features:

  • Multiple Instance support: On a server with multiple instances of SQL Server installed, each instance is automatically monitored to ensure that all appropriate services are running and functional.
  • Supports SQL Server configured in all possible authentications: SQL Server User, Windows and Domain user based authentications.
  • Supports SQL Server 2005, 2008, 2008 R2, 2012 on Windows 2008, 2008 R2 and 2012
  • Supports SQL Server on Cluster, Virtualization and IPv6 environments.


OMi Management Pack for Microsoft SQL Server: Key Features


The Management Pack discovers SQL Server components, SQL Server instances, Services, Databases and Cluster resource groups. It then deploys and activates monitoring to determine  the availability of critical SQL Server services such as:

  • The SQL Server service
  • The SQL Server Agent service
  • The availability of SQL Server for connections by querying the server for data

The service check functionality is instance and cluster aware. It also monitors Databases that are not accessible as well as Databases that are marked as suspect.


OMi Management Pack for Microsoft SQL Server: Top View showing Topology health

General performance capabilities are included, as High Availability discovery and monitoring, status of SQL health reports and backup management, errors and performance graphs all exploited from the HPBSM platform and OMi.


OMi Management Pack for Microsoft SQL Server: 360 view showing the complete health of the CI


OMi Management Pack for Microsoft SQL Server: Health Perspective to show the Health of CIs


The errors and metrics is instruments are made available to other applications such as Predictive Analytics (HP Service Health Analyzer see, Cross-domain reporting (HP Service Health Reporter see , and of course HP Operations Manager i-series Topology Based Event correlation for root cause analysis and correlated event management, health indicators, and mobile operations dashboards (see


Customers using these products are seeing 30 percent reduced costs, 60 percent increased availability for their business services and 90 percent improved efficiencies.


If you are adding MS-SQL Server to your composite applications and IT environments, it is now possible for you to gain significant cost reduction and improved efficiencies, and add an Autopilot into your Management cockpit

Feel free to reach out to me in the comments section below if you have any questions about Monitoring Automation and your MS-SQL Server.


Learn more about the Operations Bridge at our latest Google hangout here and the web event:  What is an IT Operations Bridge and who benefits from it.


You can also download HP Operations Manager i here.

Get access to more assets at and specifically the OMi Management Packs pages


  • operations bridge
0 Kudos
About the Author