+ Post New Thread
Results 1 to 10 of 10
MIS Systems Thread, PARS and SIMS extremely slow when saving and opening data in Technical; Hi, I have had lots of reports of SIMS and PARS running slowly. One example I have seen myself is ...
  1. #1

    Join Date
    Jan 2011
    Posts
    26
    Thank Post
    2
    Thanked 3 Times in 1 Post
    Rep Power
    8

    Question PARS and SIMS extremely slow when saving and opening data

    Hi,

    I have had lots of reports of SIMS and PARS running slowly. One example I have seen myself is that sometimes when a teacher tries to save a register on PARS, it takes a long time. I've seen it take about 7 minutes and I'm told that it's taken over 25 minutes before. It used to take a couple of seconds...

    The person who normally deals with SIMS and PARS is not well at the moment and won't be back in work for a while.

    After looking at some other posts on this forum I have tried watching the Activity Monitor for our database, but I don't really know what I'm watching to be honest. I have seen the "Waiting Tasks" reach over 1600, don't know if that is normal or not. I have attached a couple of screen shots of the activity monitor with the processes list sorted by the "Block By" column. I don't know if anybody was stuck on saving when these screenshots were taken.

    We are currently running SQL 2005 Enterprise and getting ready to upgrade to 2008.

    Activity Monitor 1.jpgActivity Monitor 2.jpgActivity Monitor 3.jpg

    Thanks,

    Daniel

  2. #2

    Join Date
    Jan 2011
    Posts
    26
    Thank Post
    2
    Thanked 3 Times in 1 Post
    Rep Power
    8
    Thank you for your reply. I have attached some screen shots of the query results. However again I'm not sure if it was running slow at the time. The best time to try this is in the morning. I don't know if these screen shots will tell you anything. I think a lot of the "Wait Resources" were CXPACKET or something similar this time. Because I have to run the query quickly, I didn't have enough time to look at the info on the activity monitor.

    Query 1.jpgQuery 2.jpgQuery 3.jpgQuery 4.jpgQuery 5.jpg

    Thanks,

    Dan

  3. #3

    Join Date
    Jan 2011
    Posts
    26
    Thank Post
    2
    Thanked 3 Times in 1 Post
    Rep Power
    8
    Quote Originally Posted by jinnantonnix View Post
    First thing - you're on SQL 2005 SP2, you should patch it to SP4. SP3 contains fixes for blocking issues. Try this and see if it helps.

    Scratch that - you should move to SQL 2008 as the SIMS platform is officially SQL 2008. You might not be able to get any support for your platform. I know there's a few people in the same boat, but you should be on SQL 2008 by now.
    I actually installed 2008 this morning but we haven't migrated SIMS yet. We are hoping to do the migration sometime next week. I will monitor SIMS and PARS for a couple of days after the migration and let you know if it has solved the problem. Thank you for your help.

    Daniel

  4. #4

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,316
    Thank Post
    35
    Thanked 351 Times in 237 Posts
    Rep Power
    78
    It's unlikely to be resolved through moving to SQL 2008. If you haven't done so please log a case.

  5. #5
    The_Windy_Miller's Avatar
    Join Date
    Aug 2007
    Posts
    25
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    15
    Make sure you're using SQL 2008 Release 1 - Release 2 is not officially supported by SIMS at present

  6. #6

    Join Date
    Jan 2011
    Posts
    26
    Thank Post
    2
    Thanked 3 Times in 1 Post
    Rep Power
    8
    Quote Originally Posted by The_Windy_Miller View Post
    Make sure you're using SQL 2008 Release 1 - Release 2 is not officially supported by SIMS at present
    Thank you, how can I check this? Do you mean Service Pack 1 and 2 or is that something different?

  7. #7

    Join Date
    Jan 2011
    Posts
    26
    Thank Post
    2
    Thanked 3 Times in 1 Post
    Rep Power
    8
    The query gives me this:

    Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)

  8. #8

    Join Date
    Jan 2011
    Posts
    26
    Thank Post
    2
    Thanked 3 Times in 1 Post
    Rep Power
    8
    So am I right in thinking that I should install Service Pack 1 but NOT Service Pack 2?
    Last edited by stanwell; 10th January 2011 at 12:11 PM.

  9. #9

    Join Date
    Jan 2011
    Posts
    26
    Thank Post
    2
    Thanked 3 Times in 1 Post
    Rep Power
    8
    Eveything seems to be running a lot better now. We have migrated to SQL 2008, updated SIMS to the Autumn 2010 release and updated PARS to 2.451.

    Thank you for your help.

    Dan

  10. #10
    jenny_urey's Avatar
    Join Date
    Nov 2007
    Location
    Home: Telford Office: Wolverhampton Work Travel: all over UK!
    Posts
    124
    Thank Post
    31
    Thanked 11 Times in 10 Posts
    Rep Power
    17
    Quote Originally Posted by stanwell View Post
    Eveything seems to be running a lot better now. We have migrated to SQL 2008, updated SIMS to the Autumn 2010 release and updated PARS to 2.451.

    Thank you for your help.

    Dan
    Any further issues - please give our support desk a ring as we may be able to advise

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] sims.net slow when saving record
    By itgeek in forum MIS Systems
    Replies: 15
    Last Post: 13th May 2013, 03:33 PM
  2. Boardworks Powerpoint's Opening Extremely Slooooowwww
    By darrenmcginnis in forum Office Software
    Replies: 1
    Last Post: 20th October 2010, 08:47 PM
  3. sims slow to save data for some users
    By maark in forum MIS Systems
    Replies: 12
    Last Post: 2nd February 2010, 08:59 AM
  4. Replies: 21
    Last Post: 19th October 2009, 10:18 PM
  5. Symantec Ghost running extremely slow
    By gingesean in forum O/S Deployment
    Replies: 3
    Last Post: 16th July 2009, 10:08 AM

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
  •