Statistics for temp table

Question

Statistics for temp table

Viewing 6 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

Ninja's_RGR'us (3/21/2011)
we need the actual .sqlplan file!

and the table definitions, query and any index definitions please.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 2

sqlchanakya (3/21/2011)
It my bad....11%

What's 11%?

Ninja was talking about the sp_config setting Cost Threshold for Parallelism, which is a number, default 5.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Latheesh NK SSCertifiable Points: 6559 More actions · Answer 3

Please find the plan as attached.

This is a cached plan....

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 4

That is an estimated plan. It's missing a whole lot of useful information.

Please run the query (and just the query that's of interest, not the entire procedure) with the 'Include actual execution plan' option turned on. Once the query has completed, right click the plan, chose save as, save it as a .sqlplan file and upload it.

Also please post the table definitions, query text and any index definitions.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Latheesh NK SSCertifiable Points: 6559 More actions · Answer 5

If am wrong, please correct me.

Actually as I mentioned, am not able to see parallelism in any of my servers other than in my production. However I am not able to see the execution plan at production due to security reason(Actual plan). Thats the reason I sent across the cached plan.

Let me try to get the plan and sent to you.

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 6

Send the query (and just the query that's showing this behaviour, not the entire stored proc) to the DBA and ask him to run it with the actual plan on.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass