SQL 2005 Performance -- sql server connect

Andrew J. Kelly
8/6/2007 12:00:00 AM

It all depends on what they are doing and how. Yes some things are slower in
2005 than 2000. But the majority is just as fast or faster in 2005. It is
very likely that the 3rd party vendor doesn't have a clue when it comes to
SQL Server and simply hasn't tuned it properly. Unless they can give you a
real reason why it is slower (have them show proof) then they simply don't
know what they are talking about. My guess would be that with better
hardware and upgrading the OS and SQL Server you should see an improvement
over all. Just make sure to update the statistics after you upgrade or
restore the db from 2000 to 2005.

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]

N Rajan
8/6/2007 3:24:01 AM

HI,
Currently would like to migrate my server from Win 2000 running SQL 2000 to
Win 2003 and SQL 2005. We do have 2 inhouse program and ACCPAC (accounting)
pack accessing the SQL database. According to my 3rd party software house
that changing to SQL 2005 the performance is slower compared to SQL 2000. My
management is not questioning me how is this possible as the 3rd party
software house is using one of his customer as reference using SQL 2005. Due
to this my management is confused to proceed for migration to SQL 2005.
We are actually getting a new HP server (high-end) which is more then
enought for Windows 2003 and SQL 2005 to run, but they would like to get some
feed back from microsoft to ensure the performance of thenew SQL 2005 is
better then SQL 2000. Would aprpeciate if you could help me to explain the
performance difference between Win2000 running SQl 2000 and Win 2003 running
SQL 2005 which I can forward to my management.

regards
rajan
email : rajan@firstmobile.com.my
email : rajan_sri@hotmail.com

sql server connect : SQL 2005 Performance