AnsweredAssumed Answered

Server performance

Question asked by ryyno10 on Feb 27, 2012
Latest reply on Mar 9, 2012 by philmodjunk

Title

Server performance

Your post

HP
Intel Xeon X5550 @ 2.67 Ghz (2)
12 GB
64 (bit)
C drive: 136 GB
D drive: 136 GB (back up drive)

I've been dealing with increased Elapsed Time/call ( ~12000) and Wait Time/call statistic (~10000) as well as a persistant memory leak (~11 GB out of ~12 GB). 

In an effort to increase performance, we recently teamed two NIC cards on the server (Windows Server R2 2008) to allevate a possible bottle neck.  However, little improvement, if not a decrease in performance has occurred. 

Currently the cache is set at about 600 MB and my interval at 3 minutes.  I have back ups that run at 9, 11 , 1, 3, and 5, as well as nightly backups.  The backups are not set for consistency checks. 

There are 31 databases, roughly 9 gigs total, that 35 people use on a daily basis. 

As side from database design (which isn't great, I inherited a bad design), can anyone else provide suggestions to improve performance (in relation to the server or server settings)?

 

Outcomes