+ Post New Thread
Page 1 of 5 12345 LastLast
Results 1 to 15 of 64
MIS Systems Thread, SQL2008 VERY SLOW FOR ALL USERS in Technical; Good Afternoon, Our school are having major problems since upgrading from SQL2005 to SQL2008. Users are reporting both SIMS and ...
  1. #1
    Darylrese's Avatar
    Join Date
    Sep 2010
    Location
    Portsmouth
    Posts
    422
    Thank Post
    10
    Thanked 7 Times in 6 Posts
    Rep Power
    10

    Angry SQL2008 VERY SLOW FOR ALL USERS

    Good Afternoon,

    Our school are having major problems since upgrading from SQL2005 to SQL2008. Users are reporting both SIMS and PARS are running VERY slowly. When running a simple report it can take upto 20mins or crashes out completely.

    The sims.ini and connect.ini are correct, the MIS Server is not under stain according to the performance manager in both windows and SQL studio 2008.

    The problem seems to be fairly random. Sometimes it runs ok and other times grinds to a halt. Users report even the quicker times are slower than they used to be with SQL2005.

    TASC who make PARS have spent several hours looking at the SQL database and server and can't find anything wrong with it. All patches / updates for both SIMS and PARS have been applied.

    Any ideas? Its driving us nuts!!!

    Thanks!

  2. #2

    Join Date
    Mar 2010
    Location
    UK
    Posts
    175
    Thank Post
    0
    Thanked 17 Times in 16 Posts
    Rep Power
    17
    Is it the express version of SQL and have you virtualised it?

  3. #3

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,256
    Thank Post
    182
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    We have found lately that Sophos hogs the resources and SQL gets the blame.

  4. #4

    teejay's Avatar
    Join Date
    Apr 2008
    Posts
    3,222
    Thank Post
    287
    Thanked 782 Times in 591 Posts
    Rep Power
    346
    Run patch 6635 on the SIMS database, this does a reindex and database check. Running this fixed the same problem for us after upgrade.

  5. #5

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,821
    Thank Post
    272
    Thanked 1,140 Times in 1,036 Posts
    Rep Power
    350
    Have exactly the same problem - have our sims support team constantly looking at the problem

  6. #6
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    445
    Thank Post
    153
    Thanked 77 Times in 61 Posts
    Rep Power
    32
    Funny I've generally seen SQL2008 improve response times, this is particularly noticeable with FMS. At the moment I'm going out moving it from SQL'05 to SQL'08 every single day in primary schools with varying systems. (As always the very first load time is slow on each workstation when compared with subsequent loads better - SQL '08 does feel quicker though).

    I agree with Creese as well, if Sophos is what you use for an AV solution it does seem to slow things up a lot, particularly on the times SIMS needs to do a local workstation upgrade. However this was the case under SQL '05 - you just need to add the right exceptions.

    Go for teejays suggestion too, it increases the size of the DB a tiny amount but usually reaps a benefit.

    I know you said the Server isn't the issue but some thoughts on it nonetheless:

    1. Firewall settings - make sure all the ports and the application are specifically defined as exceptions.
    2. Is the SIMS specific instance of SQL2005 still running? If so stop and disable it, if possible uninstall it.
    3. Relevant to the above point are the workstations connect.ini's right or is redirection via the 2005 instance being used?
      NB - What I mean here is that you may have changed the main connect.ini (eg - S:\SIMS\Connect.ini) but local ones in "C:\Program Files\SIMS\SIMS .net" might still be hitting the 2005 instance and redirecting from there.
    4. Is the new 2008 instance you are using express or full and what was the old instance?
    5. If it is the full SQL, have you looked at the number of cores that SQL '08 is allowed to use for the SIMS specific instance and compared that to your old version?
    6. Coming off the back of the school hols have you had any major work done at all - are you noticing slower load speeds with any other applications?


    Sorry, this is a long list but I hope it gives you some ideas of where to look. The firewall thing is unlikely as I don't think SIMS would even open if there was anything amiss there.

    I hope you find the problem.
    Last edited by superfletch; 27th September 2010 at 05:39 PM. Reason: spelling issues

  7. Thanks to superfletch from:

    Darylrese (28th September 2010)

  8. #7
    Darylrese's Avatar
    Join Date
    Sep 2010
    Location
    Portsmouth
    Posts
    422
    Thank Post
    10
    Thanked 7 Times in 6 Posts
    Rep Power
    10
    Hi,

    thank-you for your responses. I have run the command exec sp_who2 and we have no entries in the BlkBy column, just -'s

    I believe we have SQL2008 R2 Standard edition installed.

    SQL2005 is still installed on the server but not sure without checking if it has been disabled as our local council came in and did the upgrade for us.

    All the is specified in the local connect.ini is:
    [SIMSConnection]
    Redirect=O:\SIMS

    We had a new wireless system put in over the summer holidays (7 access points connected straight to an aruba switch) as well as the upgrade to SQL2008. Nobody seemed to be complaining on the first week back. We also rolled out SP3 for Windows XP over the summer.

    Where do we download the 6635 patch from please?

    Thanks
    Last edited by Darylrese; 28th September 2010 at 10:02 AM.

  9. #8

    Join Date
    Jan 2006
    Location
    Surburbia
    Posts
    2,178
    Thank Post
    74
    Thanked 307 Times in 243 Posts
    Rep Power
    115
    I believe we have SQL2008 R2 Standard edition installed.
    I wanted to know which edition? in some code and it wasn't anywhere near as straightforward as I expected e.g. just go look in add/remove or whatever. Ended up connecting to the DB and running this query:

    select SERVERPROPERTY('productversion'), SERVERPROPERTY ('edition')

  10. #9
    Darylrese's Avatar
    Join Date
    Sep 2010
    Location
    Portsmouth
    Posts
    422
    Thank Post
    10
    Thanked 7 Times in 6 Posts
    Rep Power
    10
    10.50.1600.1 Standard Edition

  11. #10

    teejay's Avatar
    Join Date
    Apr 2008
    Posts
    3,222
    Thank Post
    287
    Thanked 782 Times in 591 Posts
    Rep Power
    346
    Quote Originally Posted by Darylrese View Post
    Hi,

    thank-you for your responses. I have run the command exec sp_who2 and we have no entries in the BlkBy column, just -'s

    I believe we have SQL2008 R2 Standard edition installed.

    SQL2005 is still installed on the server but not sure without checking if it has been disabled as our local council came in and did the upgrade for us.

    All the is specified in the local connect.ini is:
    [SIMSConnection]
    Redirect=O:\SIMS

    We had a new wireless system put in over the summer holidays (7 access points connected straight to an aruba switch) as well as the upgrade to SQL2008. Nobody seemed to be complaining on the first week back. We also rolled out SP3 for Windows XP over the summer.

    Where do we download the 6635 patch from please?

    Thanks
    You may well find it kicking around on your sims server, search for Patch_6635_Reindex if you haven't got it, contact your support provider for it or if no joy pm me.

  12. #11
    Darylrese's Avatar
    Join Date
    Sep 2010
    Location
    Portsmouth
    Posts
    422
    Thank Post
    10
    Thanked 7 Times in 6 Posts
    Rep Power
    10
    Thanks, I have done a search and cant find it anywhere. We are asking our provider for it.

    I am using Microsoft SQL Server Management Studio and we have all sorts of processes being blocked by each other. See screen shot below. This is when the system comes to a halt:

    Last edited by Darylrese; 28th September 2010 at 10:53 AM.

  13. #12
    Darylrese's Avatar
    Join Date
    Sep 2010
    Location
    Portsmouth
    Posts
    422
    Thank Post
    10
    Thanked 7 Times in 6 Posts
    Rep Power
    10
    sorry i have corrected the link...should now work.

    Cheers

  14. #13
    Darylrese's Avatar
    Join Date
    Sep 2010
    Location
    Portsmouth
    Posts
    422
    Thank Post
    10
    Thanked 7 Times in 6 Posts
    Rep Power
    10
    Quote Originally Posted by jinnantonnix View Post
    It looks like locks are your problem.
    From your picture, it seems SPID 86 is being blocked by SPID 110. Can you see what SPID 110 is doing? If it's being blocked by SPID 86 you have a deadlock.
    Hi,

    The screenshot doesn't show it but there are several other SPID's blocking each other aswell. As we speak there arn't any SPID's blocking each other...it just seems to all happen at once then sort itself out after 10mins or so...but for this duration it crashes everyones SIMS and PARS causing them to log off.

  15. #14
    Darylrese's Avatar
    Join Date
    Sep 2010
    Location
    Portsmouth
    Posts
    422
    Thank Post
    10
    Thanked 7 Times in 6 Posts
    Rep Power
    10
    yes will do. If i can grab a screen shot when it next happens i will post it on here. We are just giving Capita and our local council a ring to see what they say

  16. #15
    Darylrese's Avatar
    Join Date
    Sep 2010
    Location
    Portsmouth
    Posts
    422
    Thank Post
    10
    Thanked 7 Times in 6 Posts
    Rep Power
    10
    Certainly will. Thank-you for your help so far.



SHARE:
+ Post New Thread
Page 1 of 5 12345 LastLast

Similar Threads

  1. SQL2008 Express Reboot Rule Fails
    By Rawns in forum Windows
    Replies: 0
    Last Post: 11th August 2010, 12:33 PM
  2. SIMS - SQL2005 > SQL2008 Migration Problem
    By RobFuller in forum MIS Systems
    Replies: 26
    Last Post: 24th March 2010, 11:39 PM
  3. sims slow to save data for some users
    By maark in forum MIS Systems
    Replies: 12
    Last Post: 2nd February 2010, 09:59 AM
  4. Help Please june Update + sql2008
    By woodham in forum MIS Systems
    Replies: 7
    Last Post: 6th July 2009, 04:26 PM
  5. Moodle - Slow when more than a few users are logged in
    By wesleyw in forum Virtual Learning Platforms
    Replies: 18
    Last Post: 21st September 2007, 03:34 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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