MS SQL Server - RE: Performance issues after migrating from sql server 2K to 2005 Expr

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

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

SBAUER

2006-04-07, 1:23 pm

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?
>
>

Sponsored Links