Home Forums SQL Server 7,2000 Performance Tuning cpu utilization RE: cpu utilization
Andy Warren
SSC Guru
Points: 119747
More actions
June 30, 2003 at 4:48 pm
#463708
I'd say you probably need more memory. The page swapping is drive up your CPU load. Check drive IO while you're looking, it's probably high as well. All things considered, more memory never hurts and is easier to add than drive space.
Andy
http://qa.sqlservercentral.com/columnists/awarren/
Andy SQLAndy - My Blog! Connect with me on LinkedIn Follow me on Twitter