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 ...
27th September 2010, 04:42 PM #1
SQL2008 VERY SLOW FOR ALL USERS
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!!!
IDG Tech News
27th September 2010, 05:10 PM #2
- Rep Power
Is it the express version of SQL and have you virtualised it?
27th September 2010, 05:19 PM #3
We have found lately that Sophos hogs the resources and SQL gets the blame.
27th September 2010, 05:26 PM #4
Run patch 6635 on the SIMS database, this does a reindex and database check. Running this fixed the same problem for us after upgrade.
27th September 2010, 05:34 PM #5
Have exactly the same problem - have our sims support team constantly looking at the problem
27th September 2010, 05:35 PM #6
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:
- Firewall settings - make sure all the ports and the application are specifically defined as exceptions.
- Is the SIMS specific instance of SQL2005 still running? If so stop and disable it, if possible uninstall it.
- 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.
- Is the new 2008 instance you are using express or full and what was the old instance?
- 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?
- 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
Thanks to superfletch from:
Darylrese (28th September 2010)
28th September 2010, 09:44 AM #7
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:
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?
Last edited by Darylrese; 28th September 2010 at 10:02 AM.
28th September 2010, 10:12 AM #8
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:
I believe we have SQL2008 R2 Standard edition installed.
select SERVERPROPERTY('productversion'), SERVERPROPERTY ('edition')
28th September 2010, 10:17 AM #9
10.50.1600.1 Standard Edition
28th September 2010, 10:18 AM #10
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.
Originally Posted by Darylrese
28th September 2010, 10:46 AM #11
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.
28th September 2010, 10:54 AM #12
sorry i have corrected the link...should now work.
28th September 2010, 11:35 AM #13
Originally Posted by jinnantonnix
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.
28th September 2010, 11:48 AM #14
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
28th September 2010, 11:55 AM #15
Certainly will. Thank-you for your help so far.
By Rawns in forum Windows
Last Post: 11th August 2010, 12:33 PM
By RobFuller in forum MIS Systems
Last Post: 24th March 2010, 11:39 PM
By maark in forum MIS Systems
Last Post: 2nd February 2010, 09:59 AM
By woodham in forum MIS Systems
Last Post: 6th July 2009, 04:26 PM
By wesleyw in forum Virtual Learning Platforms
Last Post: 21st September 2007, 03:34 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)