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!!! :wacko: