Another option:
Point your web browser to:
http://remedyserver:9090/bmc/backplane/stats
You should see a graph of:
- filters sorted by # of times run
- filters sorted by total time consumed
- escalations sorted by # of records modified
- escalations sorted by total time consumed
Also:
- a list of all tables on the system sorted by # of records / table.
- a list of all tables sorted by disk size
If you click on the "trends" tab -- you should see the above with
historical values.
The above should be helpful in pinpointing your issues.
OK - OK -- I am sorry -- I have to quit dreaming -- it just makes you
depressed.
-John
On Feb 18, 2010, at 12:56 PM, LJ Longwing wrote:
**
Tim,
That doesn't seem excessive to me....whenever I'm looking at
performance issues I turn on SQL and API logging at the server and run
the ARLogAnalyzer against them...it tells me which processes are
taking to long and I tweak that workflow, indexes, etc.
From: Action Request System discussion list(ARSList) [mailto:[email protected]
] On Behalf Of Tim Rondeau
Sent: Thursday, February 18, 2010 11:43 AM
To: [email protected]
Subject: Performance issues
**
Arsystem 7.1 patch 7 ITSM suite, using SLM, CMDB, Change Management,
Problem and Incident
We are running SQL 2005 on windows 2003 server, plenty of CPU/disk and
RAM.
Looking for some feed back on how some have handled performance issues.
We process about 400 changes a day and about 800 incidents a day.
Just seems like this system can’t handle it. DB timeouts, white
screens all the time. DBA of course states no issues.
In March we are moving to Oracle RAC, which will be 2 robust db
servers. APP will still be on windows.
Thanks
Tim
_Platinum Sponsor: [email protected] ARSlist: "Where the
Answers Are"_ _Platinum Sponsor: [email protected] ARSlist:
"Where the Answers Are"_
--
John Sundberg
Kinetic Data, Inc.
"Building a Better Service Experience"
Recipient of the WWRUG09 Innovator of the Year Award
[email protected]
651.556.0930 I www.kineticdata.com
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
