New post
Question
· Aug 11, 2017

What in the System Dashboard indicates performance issues?

#Monitoring #Performance #Caché

Please excuse my ignorance. I am trying to identify what areas would be best to review in the System Dashboard (for Cache 2010.2) for performance issues with the database. It seems to be running slower than usual, but I am trying to find out the best way to go about identifying what the issue is.

The following are captures from the System Dashboard.

As always, thanks a lot for your help.

System Dashboard

Global and Routine Statistics

ECP Statistics

Disk and Buffer Statistics

Discussion (3)2
Log in or sign up to continue
Jon Sue-Ho · Aug 15, 2017

Additionally, you may want to look at this series of posts about performance in general:
https://community.intersystems.com/post/intersystems-data-platforms-capa...

There are a lot of posts that cover quite a bit of ground, so it may be more than you bargained for, but performance issues are usually more complicated than we wish they were.

In particular, you want to read the first article on setting up and running pButtons (and the link on downloading the latest version of pButtons).  pButtons is a utility that captures various performance metrics at both the Cache and the host levels (including mgstat outputs like the ones asked for in other comments to this post); it is most useful when you have pButtons outputs from times of normal operation and from times of problem operation so they can be compared for differences.  If you're planning to open a WRC case, having pButtons from during the time of the problem and from during normal operation would be a definite plus.

2 0