What in the System Dashboard indicates performance issues?

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

Vote up!
Vote down!

Rating: 2

Comments: 3 Views: 95


Hi Mack;

Can you open your terminal and go and run this command.

%SYS> DO ^mgstat(5,17280,,10)

After at least 20 entries capture the screen shot and post here, for in-depth pointers.



Vote up!
Vote down!

Rating: 2

The following is the capture requested with the exception of the fields that were trimmed due to them all being 0. The fields trimmed were RemGrefs, GRratio, RemGupds, RemRrefs, RemRLaS, GblSz, pGblAsz, RouSz, pRouAsz, ObjSz, pObjAsz, ActECP, Addblk, PrgBufL, PrgSrvR, BytSnt, BytRcd, and IJULock.


Vote up!
Vote down!

Rating: 0

Additionally, you may want to look at this series of posts about performance in general:

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.



Vote up!
Vote down!

Rating: 1

Log in to answer