Re: Poor performance after upgrading to sql server 2005

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

All considerations done seems to not consider a very important fact: THE
PERFORMANCE DECREASE DAMATICALLY ALSO WITH SQL 2000 IF YOU REINDEX ALL
THE TABLES! Why?

I have experienced the same thing with our database. This is a 13 GB
database with a lot of transactions.
I've installed SQL2005 in the same machine and attached the db File to
SQL2005 and the performance was poor.
Then I've installed SQL2000 (std.) + SQL2005 (64 bit version) in our new
server (IBM dual Xeon 3,0 GHz / Win2003 Ent. x64) with the same results.
This 2nd time I have recovered the Database from backup.
The 2000 was normal and 2005 very slow.
I think the reason lies in the index keys. As I think that when we
recover or attach a 8 version to a 9 database during the operation some
thing was rebuilded...

What do you think about?
Let me know please!



*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: RMAN help
    ... Database mounted. ... RMAN> recover database; ... allocated channel: ORA_DISK_1 ... Starting restore at 11-MAY-06 ...
    (comp.databases.oracle.server)
  • Re: event id 474: inconsistent ntds.dit
    ... If you have a recent backup I recommend you to perform restore ... can try to repair the Database, In some situation, certain ... How to Recover the Database and if it fails try How to Repair the ... Open a command prompt and run NTDSUTIL to verify the paths for the ...
    (microsoft.public.win2000.active_directory)
  • Re: Recovering Deleted Tables
    ... There are only four ways to recover a deleted table without incurring ... this method is useless as soon as the database is closed or ... Restore from backup. ... I felt this to be a little steep. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: DCPromo and NTDS.DIT
    ... - You may try the following steps to recover the corrupted Active Directory, ... Active Directory database is unavailable because it is damaged, ... Open a command prompt and run NTDSUTIL to verify the paths for the ...
    (microsoft.public.windows.server.active_directory)
  • Re: NTDS ISAM DataBase Corruption
    ... You may try the following steps to recover the corrupted Active ... Active Directory database is unavailable because it is damaged, ... Open a command prompt and run NTDSUTIL to verify the paths for the ...
    (microsoft.public.windows.server.active_directory)