SQL Server Performance Forum – Threads Archive

Databases backward compatibility

Hi ,
I have 2k Server in which I have databases which are backward compatible . Will this be any problem for performance.. Regards,

---

Is it a 70 or 65?
Have you observed anything lately on the performance aspect? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

---

It is 65 only.. It’s been long time we migrated to 2k. Users always complain that server is slow .. Regards,

---

CHeck the long running queries and try to optimize them with supported indexes & plans.
Compatibility doesn’t mean it will address every problem, sometimes they will be mounted due to the matter too. Also SQL 6.5 is out of support and you may not get much joy in resolving the issue, so sooner the better to upgrade the database to SQL 2000 version. http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx#EMCAG fyi on compatibility aspect. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

---

Thank you satya.. But my doubt here is , will this make any significant difference in performance if I upgrade my application code from 6.5 to 80 Regards,

---

Yes it will, you can test the same on your development environment to see the difference. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

---

]]>