IMHO, Server Statistics are more useful for doing a current system comparison from current state with previously collected statistics and not quite for cross system comparisons like you are looking for. You may get feeds from others with varying values but those values are retrieved from systems that have parameters that are different from yours that could affect those numbers. Apart from just the regular hardware specs, some systems may be dedicated, some not, so what really would be the use of seeing those numbers across different systems?
For investigating system meltdowns, your starting point should be your own system. You first rule out specs – whether or not you are short changed on certain things.. you then look at your DB. Then your code (searches, indexes).. Reviewing your own current server state from server statistics while tuning these parameters may help, but I see this more of a management tool for reporting server health than really a tool to provide an insight into what needs to be tuned.... Joe From: Logan, Kelly Sent: Thursday, September 08, 2011 1:26 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Server Statistics - Process time ratios ** This is a quick question for other admins that have or are running Server Statistics, particularly on several systems. I am troubleshooting some slowdowns on our ARS 7.1 server, running a heavily customized ITSM 7.0.3. I have started Server Statistics and found the following process time values: Process Time 1/100ths second ARServer Idle Time 16,635,760 API Requests 7,422,478 DB SQL 7,394,727 Entries Calls 7,385,638 Get List Entry 7,331,214 Escalation 2,194,126 Non DB Restructure 36,347 Filter 28,006 Create Entry 23,163 Set Entry 19,428 Delete Entry 1,821 Get Entry Stats 210 Cache Loading 0 FTS 0 Merge Entry 0 I haven’t really looked at these before on a normally functioning system, so I’m throwing it out to those who have: Are these relatively normal ratios compared to other systems you’ve seen; i.e., are API, DB SQL, Entries and Get List process times usually 100x the others’? Thanks for your time! Kelly Logan, Sr. Systems Administrator (Remedy), GMS ProQuest | 789 E. Eisenhower Parkway, P.O. Box 1346 | Ann Arbor MI 48106-1346 USA | 734.997.4777 kelly.lo...@proquest.com www.proquest.com ProQuest...Start here. 2010 InformationWeek 500 Top Innovator P Please consider the environment before printing this email. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender, and delete the message from your computer. _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
