Posted by traceable1 on 10/26/07 16:09

sorry for not including enough info.

Yes, we have several servers/instances.

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.

For a temporary band-aid, I am replicating this shared database to the
other instances and that seems to be getting us by.

I sure would like to see a fix for this, though!


Thanks!!


On Oct 25, 4:27 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> traceable1 (thham...@gmail.com) writes:
> > I installed the SQL Server 2005 SP2 update 2 rollup on my 64-bit
> > server and the performance has tanked!
>
> > I installed rollup 3 on some of them, but that did not seem to help.
>
> > I thought it was just a linked server performance issue, but my
> > optimization started running today on one of the "update 2" instances
> > and so far it's been running about 10 hours longer than it normally
> > does.
>
> Exactly what performance has dropped? Queries in general? Specific
> queries or actions? You mention "my optimization", is that the reindexing
> job.
>
> You first say "my server" in singular, and then continued with "some of
> them" and talks about "instances". Am I right to conclude that this is
> one machine with several instances, and all are slow?
>
> Sorry for asking questions, but there is not really much information to
> work from in your post.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]