MIS Systems Thread, sims.net SQL Server CPU Spike in Technical; Hi I have had a problem this morning with CPU hitting 100% for about 5 mins. This was the first ...
26th February 2009, 09:06 AM #1
- Rep Power
sims.net SQL Server CPU Spike
Hi I have had a problem this morning with CPU hitting 100% for about 5 mins. This was the first lesson and having trouble logging into sims.net. After the 5 mins people where into Sims and working fine. How can we stop the spike, can we configure sql or change setting?
26th February 2009, 09:18 AM #2
I'm a little rusty having left the SIMS helpdesk a couple of years ago, but...
The first thing to try is to do a backup from system manager - this seems like an odd thing to say but it trims the SIMS.LDF file down to size and increses perfomance.
Failing that, there's a reindex patch available - request it from your local support team and apply it - then do another backup as that inflates the LDF too (allow up to an hour for DbUpgrade to run it).
What version of SQL Server are you running and how many users have you got?
Last edited by BatchFile; 26th February 2009 at 09:22 AM.
26th February 2009, 09:26 AM #3
Was there a scheduled task or anything similar running at that time which might've caused the load?
26th February 2009, 09:30 AM #4
The 2 biggest times when we get CPU spikes is...
1) When I am running Database Diagnotics (so this will only happen if you are running it).
2) When the admin staff delete a student from Sims - This stops anyone logging onto Sims and lasts about 20-30 mins on our system.
26th February 2009, 09:54 AM #5
Another thought drifted into my head...
when you say users can't log in, do you mean they hang for ages but get in eventually, or do they actually fail with a timeout fault code?
if it's the latter, adding
to the connect.ini file, just below the "databasename=" line, will stop it from timing out
Last edited by BatchFile; 27th February 2009 at 11:35 AM.
Reason: corrected the "commect.ini" file name to "s:\sims\connect.ini"
Thanks to BatchFile from:
itgeek (26th February 2009)
26th February 2009, 10:33 AM #6
- Rep Power
Thanks Tony for the info, it sound very interesting. i will have a play and let you know how I get on. The user waits about 90 seconds then gets in. We are running SQL 2005 Full verison.
26th February 2009, 12:28 PM #7
Just checking as the lesser versions don't use all available server resources
Originally Posted by itgeek
By itgeek in forum MIS Systems
Last Post: 14th March 2008, 06:02 PM
By dhicks in forum MIS Systems
Last Post: 14th December 2007, 09:05 AM
By tscnmuk in forum MIS Systems
Last Post: 20th July 2007, 12:58 PM
By Uraken in forum MIS Systems
Last Post: 27th February 2007, 08:09 PM
By projector1 in forum Hardware
Last Post: 7th July 2006, 02:21 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread