ServiceNow Performance Metrics

If you’ve ever had performance issues within ServiceNow, chances are you’ve gone to look at the performance dashboards to see if anything looks “funny” there. If not, you then check the stats.do page.

Recently I’ve been working on automated monitoring, spotting a situation arising before the customer notices the system is going into slowdown.

While doing this I’ve discovered a new table with a whole load of metrics to read from.

This table is cmdb_metric table. It has loads of extensions to it (25 to be precise) which monitor stores results for all sorts of stuff, semaphore queues, memory usage, cpu utilization – all of this separated by node too.

All these metrics are extremely useful for either automated monitoring or if looking into it manually, you can go back to a point in time and see how the performance was during a period of slowness.

I haven’t checked how long the metrics are kept for, but I’d expect them to be held for no longer than 30 days in a similar fashion to most of ServiceNow logging.

7 Comments

  1. Here’s a thread saying the same, it existed, in Jakarta it doesn’t. They suggest using xmlstats.do. However it isn’t like you easily get that from a server script, you can however, get the same data from sys_cluster_state records. You’ll have to view the XML but if you Gliderecord you can get to it the same.

    Like

    • Yeah the data it logs in the sys_cluster_state table is useful but almost requires rebuilding metric table. Will need to look at recording the relevant stats every X minutes.

      The stats shows a point in time state whereas the metric tables allows you to monitor trends (ie, if memory is high for 30 seconds, I don’t care. If it’s high for 5 minutes, then that might be more concerning).

      Like

  2. Right, at a former place I wrote a thing to do just that with the data from sys_cluster state. every 5 minutes, capture the data, write to a table. Made reports. It was our dashboard.
    The problem is SN sometimes changes the nodes up on you without notice.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s