DZone Database Zone
Execution Plan Metrics and Units of Measure
Have you ever looked at the properties of an execution plan and wondered what the units of measure were? I know I have. I also get the question pretty frequently about all sorts of properties. What does EstimatedAvailableMemoryGrant display its units in, anyway? For that matter, what the heck is an EstimatedAvailableMemoryGrant?
ShowPlan Schema and Units of MeasureThe answer to those questions and a whole lot more is pretty easy to find. You just have to look at the ShowPlan Schema. Microsoft has all the schemas published, going back to 2005. The next time you're faced with a question such as, "What are the units of measure of the MemoryGrantInfo?"
No comments:
Post a Comment