+ Post New Thread
Results 1 to 7 of 7
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 ...
  1. #1

    Join Date
    Feb 2008
    Posts
    325
    Thank Post
    51
    Thanked 3 Times in 3 Posts
    Rep Power
    14

    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?

    Thanks

  2. #2
    BatchFile's Avatar
    Join Date
    Aug 2007
    Location
    Cumbria
    Posts
    948
    Thank Post
    544
    Thanked 128 Times in 106 Posts
    Rep Power
    60
    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.

  3. #3

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,168
    Thank Post
    98
    Thanked 319 Times in 261 Posts
    Blog Entries
    4
    Rep Power
    113
    Was there a scheduled task or anything similar running at that time which might've caused the load?

  4. #4

    Join Date
    Dec 2005
    Posts
    535
    Thank Post
    34
    Thanked 89 Times in 79 Posts
    Rep Power
    39
    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.

  5. #5
    BatchFile's Avatar
    Join Date
    Aug 2007
    Location
    Cumbria
    Posts
    948
    Thank Post
    544
    Thanked 128 Times in 106 Posts
    Rep Power
    60
    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
    commandtimeout=99999
    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"

  6. Thanks to BatchFile from:

    itgeek (26th February 2009)

  7. #6

    Join Date
    Feb 2008
    Posts
    325
    Thank Post
    51
    Thanked 3 Times in 3 Posts
    Rep Power
    14
    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.

  8. #7
    BatchFile's Avatar
    Join Date
    Aug 2007
    Location
    Cumbria
    Posts
    948
    Thank Post
    544
    Thanked 128 Times in 106 Posts
    Rep Power
    60
    no probs

    Quote Originally Posted by itgeek View Post
    We are running SQL 2005 Full verison.
    Just checking as the lesser versions don't use all available server resources

SHARE:
+ Post New Thread

Similar Threads

  1. sims.net sql server 2005
    By itgeek in forum MIS Systems
    Replies: 2
    Last Post: 14th March 2008, 06:02 PM
  2. SIMS communication with SQL server
    By dhicks in forum MIS Systems
    Replies: 9
    Last Post: 14th December 2007, 09:05 AM
  3. SIMS & SQL Server
    By tscnmuk in forum MIS Systems
    Replies: 16
    Last Post: 20th July 2007, 12:58 PM
  4. sql server sims sa password
    By Uraken in forum MIS Systems
    Replies: 18
    Last Post: 27th February 2007, 08:09 PM
  5. Replies: 3
    Last Post: 7th July 2006, 02:21 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •