+ Post New Thread
Results 1 to 8 of 8
MIS Systems Thread, SIMS slow after migration to SQL 2008 in Technical; Did the upgrade a couple of weeks ago from SQL 2005 to 2008, since then SIMS is running much slower ...
  1. #1

    teejay's Avatar
    Join Date
    Apr 2008
    Posts
    3,174
    Thank Post
    284
    Thanked 773 Times in 583 Posts
    Rep Power
    335

    SIMS slow after migration to SQL 2008

    Did the upgrade a couple of weeks ago from SQL 2005 to 2008, since then SIMS is running much slower with lesson registration taking up to 10 minutes to appear for random users.
    Used SQL 2008 Standard and have uninstalled SQL 2005, checked performance load and that seems fine as well.
    Oh, and have phoned Capita who want to charge us hundreds of pounds to send a consultant out to look at it even though we have a support contract.
    Sooo, anyone else done the upgrade and has it worked ok or has anyone any ideas on a fix?

  2. #2

    teejay's Avatar
    Join Date
    Apr 2008
    Posts
    3,174
    Thank Post
    284
    Thanked 773 Times in 583 Posts
    Rep Power
    335
    Bump...
    Has anyone else migrated their SIMS to SQL 2008 and have you noticed any loss of speed in SIMS?

  3. #3
    Sarconia's Avatar
    Join Date
    Mar 2010
    Location
    London
    Posts
    315
    Thank Post
    15
    Thanked 34 Times in 31 Posts
    Rep Power
    15
    I've migrated numerous schools to SQL2008 and none have complained about the speed (there are a few schools who definitely would complain so if there were issues, I'd know about it!).

    I'd try what I normally do when SIMS.net is running slow, restart the SQL service, apply the re-index patch (6635), run Validate Memberships + Database Diagnostics, check the database for corruption (DBCC CHECKDB WITH NO_INFOMSGS in SQL Management Studio), check the spec of the server vs concurrent users of SIMS.net, check event logs to see if there are any SQL errors. Other than that, I can't think of anything else off the top of my head which might cause slowdown.

  4. Thanks to Sarconia from:

    teejay (18th June 2010)

  5. #4

    teejay's Avatar
    Join Date
    Apr 2008
    Posts
    3,174
    Thank Post
    284
    Thanked 773 Times in 583 Posts
    Rep Power
    335
    Thanks for that, will remote in over the weekend and try the bits you've suggested that I haven't tried already.

  6. #5

    teejay's Avatar
    Join Date
    Apr 2008
    Posts
    3,174
    Thank Post
    284
    Thanked 773 Times in 583 Posts
    Rep Power
    335
    Yeah, thanks, I know the performance tuning stuff and disk layout, SIMS was really fast on SQL 2005, it's since we upgraded it to SQL 2008 that we've run into problems. I've even tried setting up a new db server, other db's work fine, SIMS runs like a dog.
    Just ran the 6635 patch and some the other stuff, it seems a bit better now, will have to wait till Monday to find out if thats done it. Time for a few beers me thinks, oh and I think there is some footy on tonight ;-)

  7. #6

    Join Date
    Sep 2010
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Does anyone have a copy?

    Does anyone have a copy of this patch, have upgraded our sql to 2008 about a month ago but is really slow... Could you email me a copy to alcofish_uk@hotmail.com ?

    Thanks,

    rick

  8. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by hekkenberg View Post
    Does anyone have a copy of this patch, have upgraded our sql to 2008 about a month ago but is really slow... Could you email me a copy to alcofish_uk@hotmail.com ?

    Thanks,

    rick
    rick you really should request this from your local support team, so they are aware of what you are doing. it's one that can be re-run on the system, unlike most others which are only run once, nonetheless it's best if you at least let them know of the issues you're having and what route you are taking to solve them, so they are in the picture.

  9. #8

    Join Date
    Sep 2010
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    yeah thanks shall do that

SHARE:
+ Post New Thread

Similar Threads

  1. 2008 SQL migration
    By creese in forum MIS Systems
    Replies: 7
    Last Post: 3rd June 2010, 03:56 PM
  2. Who's doing their SQL 2008 Migration for SIMS today?
    By chazzy2501 in forum General Chat
    Replies: 4
    Last Post: 30th April 2010, 11:31 AM
  3. 2008 SQL migration
    By creese in forum MIS Systems
    Replies: 0
    Last Post: 22nd April 2010, 10:14 AM
  4. SIMS SQL 2008 migration utility
    By Oops_my_bad in forum MIS Systems
    Replies: 28
    Last Post: 11th February 2010, 02:29 PM
  5. SIMS SQL 2008 migration
    By matt40k in forum MIS Systems
    Replies: 0
    Last Post: 8th August 2009, 12:08 AM

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
  •