Hi Jeff,

I havn't upgrade to 2005, but i uninstalled 2000 and installed 2005 and then restored backup to 2005.

Then i did performance testing using loadrunner.

To confirm i taken one more...

Havn't tested the performance difference of SQL 2005 and SQL 2008.

Thanks for everybody's reply for confirming that SQL Server 2005 has much better performance improvement than SQL Server 2000.

Hi Paul,

If i do take restore the backup to SQL Server 2000, then also its working very slow. response time is coming 20 sec. i tried everything on 2000, but...

I have kept the hardware environment same for sql server 2000 and sql server 2005.

Hi,

Thanks for your reply.

I just taken backup of database with SQl Server 2000 server and saved it.

Then uninstalled SQL Server 2000, and installed SQL Server 2005. After that restored the...