JustinRoberts

Hi Our CPU is maxing out so often it is difficult to identify any pattern at the moment. I have used the Management suite to see what is happening but I haven't seen anything untoward. Is there a particular process fault / pattern I should be looking for?!

Thanks for your reply, its the Full 2008 Edition

Our users are experiencing intermittent disconnects and crashes when using Sims at peak times. The server is only running two SQL instances, hosting FMS and SIMS databases, a Sims file share and document storage is hosted on another server. We have 1000 students, 100 staff users and 3000 external users connecting via a hosted SLG. We have a reasonably fast SQL server: Database size = 4Gb Local Users = ~100 Processors = 2 x 2.66Ghz Xeon x5550 (Quad hyper threading cpu) Memory = 16Gb Operating System = 64 bit 2008r2 SQL System = 64 bit 2008 Network = 4 x gBit Network Document Management Server is installed on another network server running only DMS services. Please can anyone provide a more suitable response than Capita's Second Line advice, "If you Google SQL using 100% cpu you will find loads of forums etc and I believe a Microsoft KB." ?!