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 :mad: 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?