SQL Server 2008 R2 slow processing
Posted on 2010-11-25
I have a Windows Ent 2008 32-bit installation with SQL Server 2008 R2 std edition running. The problem is that runing jobs on this installation is slower on faster hardware than on an older server with windows 2003 and SQL 2005. I have more memory allocated and they are faster processes, yet the new setup is about half as slow with the same data and same job.
I had a mirror enabled which I disabled to test, reduced log files by changing recovery model from Full to Simple and shrank the files, I have tried enabling boosting SQL priority for processing in the SQL server properties. I have also run the performance tool included with SQL, there were no advised improvements suggested for the database or server.
Are there any suggestions I can do further to improve the performance?