A new SQL to the IT Operations Management cockpit story

Article written by
Manoj Mohanan

Technical Ambassador

HP Operations Management Packs and Content Packs

mohanan@hp.com

 

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.gif

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 top view.jpg

 

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 Complete health.jpg

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

 

Omi health perspective.png

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 www.hp.com/go/sha), Cross-domain reporting (HP Service Health Reporter see www.hp.com/go/shr) , 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 www.hp.com/go/omi).

 

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 www.hp.com/go/omi and specifically the OMi Management Packs pages

 

Leave a Comment

We encourage you to share your comments on this post. Comments are moderated and will be reviewed
and posted as promptly as possible during regular business hours

To ensure your comment is published, be sure to follow the Community Guidelines.

Be sure to enter a unique name. You can't reuse a name that's already in use.
Be sure to enter a unique email address. You can't reuse an email address that's already in use.
Type the characters you see in the picture above.Type the words you hear.
Search
About the Author


Follow Us
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation