The version 7 apps OTB to the best of my knowledge do not lead to performance issues like the older ITSP apps used to for lack of indexes etc.
If there were any customizations done, to any queries, on table fields etc on screens that give you those 'white screens' I would take a second look at all those customizations if you know on top of your head where those are.. Those may point out to badly designed queries against unindexed fields.. or just badly designed queries that need to be redone - period.. SQL and API logging off course will give you all the fine details - and is the best way to go to fine tune things in the end.. Then you also say you use SQL 2005.. Having plenty of disk space, CPU, RAM and other conceivable goodies doesn't guarantee that your SQL server is gonna fly. Have you look at performance check points on your SQL server? The log and data file growth configurations? Are the log files full? Are they being automatically truncated? Do you have to manually do that? Have you defragged the disk drive that the log and data files reside on? How many open connections at any point of time to the database? Is the database refusing new connections? What is the configured limit? Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Tim Rondeau Sent: Thursday, February 18, 2010 2:37 PM To: [email protected] Subject: Re: Performance issues ** Me either, thanks I will run that again and see if I can get to the bottom of this. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ Longwing Sent: Thursday, February 18, 2010 1:57 PM To: [email protected] Subject: Re: Performance issues ** 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
