The last piece of information (# of records / table and size on disk) is easily retrievable real time, if you are on Oracle.. The Oracle system view user_tables (or the table all_tables if you have administrative access to the database) should have that information among a lot of other useful information.. You would need to update the statistics for the most current information for some of it like averages etc. but if I'm not mistaken, size and number of records is real time info on that table.
I do not know the equivalent of MS-SQL or Sybase or Informix but it should not be that hard to find.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of John Sundberg Sent: Thursday, February 18, 2010 5:47 PM To: [email protected] Subject: Re: Performance issues ** 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"
