November 2, 2011 at 4:47 pm
I am trying to debug a stored procedure and I am having issues looking at the complete execution plan. It shows the execution plan to a certain extent and then it greys out as shown in the attachment. Did anyone face a similar issue before and what is the fix? I tried to set several options within management studio with no luck. Thanks a lot in advance.
November 2, 2011 at 4:54 pm
It looks like it may be too many queries and memory on your local machine is inadequate for the extreme number of queries and exec plans.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 2, 2011 at 4:59 pm
Yeah, it is a complex query. But there is enough memory on the server(55 Gb allocation to sql server, 16 CPU). With such an amount of memory and processing power, I don't think SQL Server shouldnt be short on resources.
November 2, 2011 at 5:03 pm
Are you running that combination of queries direct on the server in SSMS? Or are you running it from your desktop?
If direct on the server, you have the memory allocated to SQL server, and then the memory allocated to the OS. The memory allocated to the OS is where the memory for SSMS would be coming from.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 3, 2011 at 7:33 am
That was a good thought. I allocated more than enough memory for the OS. But I still have the same problem.
November 3, 2011 at 4:34 pm
Can you run the query and retrieve the XML - then try clicking the xml link and see if it behaves differently?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply