SQL Server Performance Forum – Threads Archive

Mode In SQL 2005

WE are in the process of migrating sql 2000 database to sql 2005 database. Now the datbase is running under test box under the native mode (80). devloper is complaining that the process is very slow comparing to sql 2000. Shall i change it to 90. Does this will increase the performance or give me some more tips to increase the performace in sql 2005. Moosa
SQL – DBA

after upgrading did you do the an reindexing. it is better to do an reindexing —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

Yes, after the upgrade we did the statisics udpate and re-index. Moosa
SQL – DBA

I am wondering whether compatibility level option has got anyhting to do with the performance of database

I am also searching for that solutions only.. do you have any idea on this… Moosa
SQL – DBA

Changing the compatibility may improve your performance but not guaranteed..
First figure it out what query/procedure is running longer in 2005 than 2000 and check the query plan on both and see the difference…
Are 2005 and 2000 servers same in HW configs? check the following threads… http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19594
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19622 MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Thanks Mohammed for the link.! Moosa
SQL – DBA

]]>