RE: Performance issues after migrating from sql server 2K to 2005 Expr

I've also attached/detached 2000 to 2005 server and am having issue with
perforamance. However, I tried to recompile and reindex tables, but am still
have same performance issues..


"patrickxkim@gmail.com" wrote:

> I recently migrated my databases to SQL Server 2005 express by
> detaching and reattaching from 2000.  Everything works properly, but I
> am having strange performance issues.  Whenever I do a rebuild or
> reindex on the tables, the performance is fine.  After a few hours, its
> terribly slow again.  I never had this issue on SQL Server 2000 and I
> actually never had to reindex the tables a single time because I never
> saw a significant drop in performance.
>
> To get performance close to before, I have to reindex all my tables on
> sql server 2005, every few hours.  Has anyone else experienced
> something similar?  Any suggestions?
>
>