February 25, 2008 at 1:54 am
We have upgraded our SQL SERVER 2000 to SQL SERVER 2005.
i couldnt find ,reason of being slower, what can you advice me to check
did we do someting wrong at set up? When we were upgrading our sql server, we just updated sql server 2000 by
selecting it at set up, and after set up we set compability level to sql 90.
Do we need to do smthing else, because we update from sql server 2000?
Our jobs execution time are extremely increased. Job which took 6 min to finish now takes 2 hrs.
Please suggest solution
February 25, 2008 at 6:46 am
You need to update the statistics on all of your tables. SQL 2005 keeps more detailed column statistics than SQL 2000 did. The 2005 optimiser can use the older stats, but not as efficiently.
You can do this by rebuilding all of your indexex (not defragmenting) or by running the updaet statistics command for each table.
UPDATE STATISTICS <Table Name>
Hope this helps.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply