IT Operations Management (ITOM)
Showing results for 
Search instead for 
Do you mean 

Get Smart - Best practice to extend metric collection on Windows

Ian_Bromehead ‎06-02-2016 04:48 AM - edited ‎06-06-2016 11:58 AM

The following is a guest post by Ramakrishna Baipadithaya Kenchabhatre, HPE OpsBridge R&D Specialist

In general many servers used in the industry have sqlserver installed by default. I was always wondering on how to collect metrics for the same, store them, draw historical graphs and generate alarms based on thresholds.
Extended Collection Builder and Manager (ECBM) came to my rescue in achieving this. ECBM allows integration of any Windows Performance monitor (perfmon) metrics into HPE Operations Agent (OA).

Let me show you how I captured the metrics using ECBM:

I started by running “mwecbm” command from my Windows command prompt. It opened up a Graphical User Interface (GUI) listing down all perfmon metrics. I selected Process->sqlserver and selected the relevant metrics. I also wanted an alarm once the value of private bytes goes beyond 4096 MB.

ECBM2.jpg

 

It is easily possible. with the help of ECBM. 

 

A Right click on the metric gives an option “Configure Metric

 

 

 

ECBM3.jpg

 

 

 

 

The next thing is to get the metrics logged at the same interval like OA does. Hence, I right clicked on the policy untitled.met) and selected “Configure Policy”.

 

 

 

 

ECBM4.jpg

 

Next I saved the policy with name “sqlserver_io_mem.met”.  

It is time to register and start the collection.  

It can be done using the GUI or using the command – mwcmcmd. I chose the GUI itself to register. 

 

 

I opened the File->Register option and selected the saved policy file. Register Collection Window opens as shown. I then clicked OK and the collection starts running.

A new data source named sqlserver_io_mem is now available and can be checked using the commands like ovcodautil.
These metrics could be seamlessly graphed using reporting tools like HPE Performance Manager.

ECBM5.jpgECBM6.jpg

Click here to sign up for the HPE Software monthly newsletter!

Try OMi now! OMi 10.10 comes pre-loaded with a number of Management Packs that you can try out without the hassle of getting management pack software or evaluation license.

Read more:

HPE Operations Bridge
HPE Live Network: Operations Bridge Evolution
HPE Live Network: Operations Manager i
HPE Live Network: OMi Management Pack development kit

Interested to learn more?

Register now for this breakout session at HPE Discover 2016 Las Vegas - BB8450: Optimize IT capacity in your cloud; learn how Exelon gained efficiency with operation agents.

To learn more about these exciting features, you can visit the Operations Agent Booth 432 at Discover

You can see demonstrations and find out more details of this and other features of our HPE Operations Bridge solution in our sessions and at our booths during HPE Discover Las Vegas.

Click on the image below or here to register.

@HPE_ITOps #HPEDiscover, #HPESW,  #itopsmgmt, #Itops

Discover.jpg

 

 

 

0 Kudos
About the Author

Ian_Bromehead

Events
June 6 - 8, 2017
Las Vegas, Nevada
Discover 2017 Las Vegas
Join us for HPE Discover 2017 in Las Vegas. The event will be held at the Venetian | Palazzo from June 6-8, 2017.
Read more
Apr 18, 2017
Houston, TX
HPE Tech Days - 2017
Follow a group of tech bloggers for a new HPE Tech Day, a full day of sessions about how to create a hybrid IT, from hyperconverged to Composable Infr...
Read more
View all
//Add this to "OnDomLoad" event