That is what I kinda figured. the problems could have existed before but we did move to "lesser" hardware that may just be exposing them now.

We haven't/can't re-index since it...

Thanks a ton ... I found some scripts that should help me out.

My question is ... can a simple file copy and what not like I did cause the indexes...

Thanks for your reply. That gives me a better feeling about trying to clean up the fragmentation.

Now is there a way to resolve fragmentation across all databases?

Remember...

One update .. I did a DBCC SHOWCONTIG WITH TABLERESULTS, ALL_INDEXES against some of the databases to check for fragmentation, and more than a few things came back with about...

Okay I've done that .. and actually was able to dig up some historical perfmon data to look for Recompiles/sec and six checks that were done over .75. When it...

I just checked and that hotfix is on.

Right now I'm at a loss .. I just don't see any reason why the performance should be so bad.

Hmmm .. I'm not certain ... (I wasn't the one who set this up) ......

I'll have to see if I can find this.

I don't have any benchmarks from the old server however, I had a query adjusted last night tht dropped the latch waits from 3000 to 160 today. But there...

Thanks for the info ... and actually this is on SQL 2000 so that article is appropriate.

I would have thought the locks should be at or close to zero .....

Thanks all for the replies. So far I've been going through every possible setting and what not.

Right now here is where I am at:

Set the parallelism to...

We have about 36 databases on that server (and thats all that runs on it) and all of them are slow. Also I don't have the numbers in front of...

we did a detach, copy and re-attach essentially.

we have updated statistics and re-indexed.

I am not opposed to doing it again, but my question is can that be done without locking...