Posted by Erland Sommarskog on 10/25/07 21:27

traceable1 (thhamlin@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, 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]