|
Posted by Erland Sommarskog on 01/15/06 01:15
serge (sergea@nospam.ehmail.com) writes:
> I wanted to find out if someone knew or had encountered this
> weird problem or may have heard it as a SQL bug or something.
> Basically I was hoping that this was a known issue and there
> was a simple explanation to it.
Unfortunately, I have never heard of this before. It sonds very strange.
> It was a big plan that I had waited for around 35 minutes before I
> got it. There were I think 2 statements of INSERT to a #temp table
> taking about 32% each so that seemed to be the big overhead in the
> execution plan.
A tip is to use SET STATISTICS_PROFILE ON. This gives you output in
text form, that you save to disk. Run this on both versions, and then
use Beyond Compare (http://www.scootersoftware.com) to compare the
output. Beyond Compare is good for this, becausee it produces diffs
on character level.
--
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]
|