SQL 6.5 Upgrade
We recently upgraded an application from MS SQL 6.5 to MS SQL 2008. We took quite a performance hit. Is this to be expected?
Software/Hardware used:
Software/Hardware used:
ASKED:
April 6, 2009 6:38 PM
UPDATED:
April 9, 2009 3:57 PM
Answer Wiki:
I have not done this upgrade, but I would not expect to see performance drop.
Some things to check and do if missing
<ul>
Have you set Maximum Memory for SQL Server
Have you changed database compatibility level to 10
Have you re-created statistics for all your upgraded databases
Do you have enough memory on the box. </ul>
If these do not do the job, then you need to look at where the slow performance is happening. There is a 'Troubleshooting Performance Problems' download for SQL 2005 that gives excellent advice and is also valid for SQL 2008. I suggest you work through that to find where your problem is.
To see all answers submitted to the Answer Wiki: View Answer History.
There will probably need to be some tweaking done to the T/SQL to get best performance, not to mention some settings changes.
Was this an in place upgrade, or did you move to a new server?
What are the specs of the server that is running SQL 2008?
Looks like I need to do a quick brush-up on SQL. Thanks for the starting points.
This application ran quite nicely for several years until the motherboard fried. We purchased a new server and and had to upgrade from Windows 2000 to Windows 2003. We were runnng SQL 6.5, which wouldn’t run on 2003 so we had to upgrade to SQL 2008.
The server is an HP Proliant DL120 G5 with an on-board Intel ICH8 SATA Raid controller and 2 Seagate Baracuda 250 gb hard drives (7200 rpm) & 4 gb memory.