Intel Xeon X5550 @ 2.67 Ghz (2)
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)?