This update adds the following new columns to the Dm_exec_query_stats dynamic management views (DMV). These columns provide statistics on memory grant and parallel threads of cached query plans. They can be useful when you investigate the query plan.

Note These columns will have a value of 0 (zero) for querying a memory-optimized table.

Column

Type

Description

Last_grant_kb

bigint

The reserved memory grant (in kilobytes [KB]) that this plan received the last time that it ran

Min_grant_kb

bigint

The minimum reserved memory grant (in KB) that this plan ever received during one run

Max_grant_kb

bigint

The maximum reserved memory grant (in KB) this plan ever received during one run

Total_grant_kb

bigint

The total reserved memory grant (in KB) that this plan received after it was compiled

Last_used_grant_kb

bigint

The used memory grant (in KB) that this plan received the last time that it ran

Min_used_grant_kb

bigint

The minimum used memory grant (in KB) that this plan ever used during one run

Max_used_grant_kb

bigint

The maximum used memory grant (in KB) that this plan ever used during one run

Total_used_grant_kb

bigint

The total reserved memory grant (in KB) that this plan used after it was compiled

Last _ideal_grant_kb

bigint

The ideal memory grant (in KB) that this plan received the last time that it ran

Min_ideal_grant_kb

bigint

The minimum ideal memory grant (in KB) that this plan ever used during one run

Max_ideal_grant_kb

Bigint

The maximum ideal memory grant (in KB) that this plan ever used during one run

Total_ideal_grant_kb

Bigint

The total ideal memory grant (in KB) that this plan used after it was compiled

Last_dop

bigint

The degree of parallelism that this plan used the last time that it ran

Min_dop

bigint

The minimum degree of parallelism that this plan ever used during one run

Max_dop

bigint

The maximum degree of parallelism that this plan ever used during one run

Total_dop

bigint

The total degree of parallelism that this plan used after it was compiled

Last_reserved_threads

bigint

The number of reserved parallel threads that were used the last time that this plan ran

Min_reserved_threads

bigint

The minimum number of reserved parallel threads that this plan ever used during one run

Max_reserved_threads

bigint

The maximum number of reserved parallel threads that this plan ever used during one run

Total_reserved_threads

bigint

The total reserved parallel threads that this plan used after it was compiled

Last_used_threads

bigint

The number of used parallel threads that were used the last time that this plan ran

Min_used_threads

bigint

The minimum number of used parallel threads that this plan ever used during one run

Max_used_threads

bigint

The maximum number of reserved parallel threads that this plan ever used during one run

Total_used_threads

bigint

The total reserved parallel threads that this plan used after it was compiled


Resolution

This functionality was fist introduced in the following Service Packs for SQL Server. 

For more information about SQL Server 2012 Service Pack 3 (SP3), see bugs that are fixed in SQL Server 2012 Service Pack 3.

Service Pack 2 for SQL Server for SQL Server 2014About Service packs for SQL Server

Service packs are cumulative. Each new service pack contains all the fixes that are in previous service packs, together with any new fixes. Our recommendation is to apply the latest service pack and the latest cumulative update for that service pack. You do not have to install a previous service pack before you install the latest service pack. Use Table 1 in the following article for finding more information about the latest service pack and latest cumulative update.

How to determine the version, edition and update level of SQL Server and its components

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×