Posted by Erland Sommarskog on 10/26/07 21:28

traceable1 (thhamlin@gmail.com) writes:
> I have 2 4-node clusters, 3 of each box running only 1 instance, the
> 4th is the spare. These have rollup update 3.
> I have 1 4-node cluster, 3 of which are running 1 instance, the 4th is
> the space. This cluster is running update 2.
>
> It appears that the performance in the optimization (defrag + stats +
> reindex) is slow now on the update 2 cluster, but the update 3 cluster
> seems to be optimizing fine.
>
> On the update3 servers, it appears that they are all using views which
> point to an instance on one of the other boxes. 5 instances contain
> the application data and they all point to the instance on the 6th box
> which contains the shared data. So the linked server is slowing
> things down.
> However, these links have always been there and have just now slowed
> to an unworkable speed since the update.

I'm still mainly in the dark. It appears that your main problem is that
the optimisation job has slowed down to a crawl on the update-2 cluster.
But then you start talking about a linked server. I can't see how the
optimisation job can be affected by the presense of a linked server.

Are these servers all part of the same application and are hosting
similar databases? Or are they completely different from each other?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]