SSMS stops while showing query execution plan

Question

Post reply

SSMS stops while showing query execution plan

riya_dave

Hall of Fame

Points: 3106
More actions
May 9, 2012 at 10:14 am

#273870

hi
when i am showing estimate execution plan,SSMS just stops working.
what causes it to stop working.
Any idea?

Viewing 7 posts - 1 through 6 (of 6 total)

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

Gazareth One Orange Chip Points: 27737 More actions · Answer 1

Stops working, or just doesn't return an execution plan in a reasonable time?

Some plans can take a while to generate!

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 2

...SSMS just stops working.
what causes it to stop working.
Any idea?

It depends, for example if you are using Amstrad or Sinclair, just buy a newer PC, something with Pentium inside should make SSMS working again.

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

drew.allen SSC Guru Points: 76987 More actions · Answer 3

riya_dave (5/9/2012)
hi
when i am showing estimate execution plan,SSMS just stops working.
what causes it to stop working.
Any idea?

Let me guess. This is the same query where you replaced a CURSOR with a WHILE loop.

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

riya_dave Hall of Fame Points: 3106 More actions · Answer 4

it just hang out and never come back.

and i am seeing ssms(not responding).

it is working for another sp.

i am using table variable ,i know for temp its not gonna work.but i dont have any temp table.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

If it's the code with the cursor, it will take ages because there will be hundreds, maybe even thousands of execution plans. If there's a cursor anywhere in the code, don't even try to look at the plans, there will be far too many and the performance problems from cursors aren't fixed by looking at the exec plan

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

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 6

i am using table variable ,i know for temp its not gonna work.but i dont have any temp table.

Who told you that for temp tables SSMS show plan is not "gonna" to work?

It does work for temp tables as fine as for table variables. Actually, do you have any good reason to use table variables over temp tables (it's just a question)?

If you could, at least for once, post the query you are talking about at the same time when asking the question, you would have more relevant answers!

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]