No Actuals

Here is the thing I have inheritedthis code. I think my biggest issue is the over use of sorts to solve problems. So I am working to simplify the query. My more general question is this came from the system_dm_ views and supposed to be the actual execution plan. BUT has no actuals. What is that telling me? Liink to any article on it would be nice so I can watch and study. Not looking to be spoonfed.

Thanks

avatar image By lnpurdie 1 asked Sep 20 at 04:37 PM
more ▼
(comments are locked)
10|10000 characters needed characters left

1 answer: sort voted first

When you retrieve an execution plan from the plan cache on a SQL Server with the "system_dm views", you are retrieving an estimated plan from the plan cache. SQL Server does not store the actual plan and runtime metrics (actuals) in cache.

With Plan Explorer (PE), you can generate an Actual plan easily with the Get Actual Plan button on the toolbar at the top of the PE client.

avatar image By SDyckes2 81 answered Sep 22 at 01:39 AM
more ▼
(comments are locked)
10|10000 characters needed characters left
Your answer
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question

Topics:

x631
x445
x114

asked: Sep 20 at 04:37 PM

Seen: 25 times

Last Updated: Sep 22 at 01:39 AM