SQL 6.5 Upgrade

15 pts.
Tags:
SQL
SQL 6
SQL 6.5
SQL Upgrades
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    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?
    66,010 pointsBadges:
    report
  • DickRich
    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.
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following