maxrebo Posted September 8, 2015 Posted September 8, 2015 Had our SQL upgraded on our SIMS and PARS server over the summer and now both are absolutely creeping!!. It was a little slow before the summer so i upgraded the RAM from 8gb to 32gb. Getting alot of complaints. Logged a call with the LA for advice Anyone got any tips on whats causing it and anything to change? Surely its not just me! God knows what it would have been like if i`d have left the server at 8gb RAM Cheers
eddyc Posted September 8, 2015 Posted September 8, 2015 Did you move your databases to SQL2014? If so, I've had this problem. Setting your SQL instance to SQL 2012 seems to sort it. Capita are aware of this "feature" Let me know how you get on! Ed
maxrebo Posted September 8, 2015 Author Posted September 8, 2015 Yes 2014. How do you go about changing the instance?
trekmad Posted September 8, 2015 Posted September 8, 2015 If you mean change the compatibility level check this out: https://msdn.microsoft.com/en-gb/library/bb933794(v=sql.120).aspx Many thanks Stuart
eddyc Posted September 8, 2015 Posted September 8, 2015 If you go into SQL Management Studio, expand databases, right click on your SIMS\PARS database and go to properties, go to the options tab and change the compatability level from SQL Server 2014 to SQL Server 2012 on the drop down. Cycle the SQL services \ reboot the server and away you go at normal speed. Ed 1
maxrebo Posted September 8, 2015 Author Posted September 8, 2015 If you go into SQL Management Studio, expand databases, right click on your SIMS\PARS database and go to properties, go to the options tab and change the compatability level from SQL Server 2014 to SQL Server 2012 on the drop down. Cycle the SQL services \ reboot the server and away you go at normal speed. Ed [ATTACH=CONFIG]32058[/ATTACH] Fantastic, i will have a look at this tomorrow
ticker Posted September 8, 2015 Posted September 8, 2015 We have exactly the same issue, staff are reporting that both are slow and we had the upgrade over summer. Be good if you could feedback if the above has helped in anyway.
PhilNeal Posted September 8, 2015 Posted September 8, 2015 It is a known problem of SQL2014 MS are aware but as yet have not provided a solution. Compatibility mode normally fixes the problem.
ticker Posted September 9, 2015 Posted September 9, 2015 SIMS database was already set on compatibility mode, but PARS wasn't changed it this morning and started to get reports that it appears quicker.
maxrebo Posted September 9, 2015 Author Posted September 9, 2015 Just made the change and already seems to be quicker! Didnt have to restart any services either which was a bonus!
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now