sys.dm_exec_query_stats

Question

sys.dm_exec_query_stats

Henrico Bekker

One Orange Chip

Points: 27652
More actions
March 26, 2017 at 9:21 pm

#335922

Comments posted to this topic are about the item sys.dm_exec_query_stats
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Viewing 9 posts - 1 through 8 (of 8 total)

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

DesNorton SSC-Insane Points: 24278 More actions · Answer 1

Well, the documentation states that these new columns were added from SQL 2016. However, they are available in my SQL 2014 instance.

SELECT @@VERSION;
Microsoft SQL Server 2014 (SP2-GDR) (KB3194714) - 12.0.5203.0 (X64) Sep 23 2016 18:13:56 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

select total_dop , total_reserved_threads , total_grant_kb from sys.dm_exec_query_stats;
total_dop total_reserved_threads total_grant_kb 3 0 3072 1 0 1872 1 0 1024

How to post data/code on a forum to get the best help.

Stewart "Arturius" Campbell SSC Guru Points: 72498 More actions · Answer 2

Interesting question, Henrico, thanks...

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 3

DesNorton - Sunday, March 26, 2017 10:22 PM
Well, the documentation states that these new columns were added from SQL 2016. However, they are available in my SQL 2014 instance.
SELECT @@VERSION;
Microsoft SQL Server 2014 (SP2-GDR) (KB3194714) - 12.0.5203.0 (X64) Sep 23 2016 18:13:56 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
select total_dop , total_reserved_threads , total_grant_kb from sys.dm_exec_query_stats;
total_dop total_reserved_threads total_grant_kb 3 0 3072 1 0 1872 1 0 1024

That is quite interesting. Thanks for sharing.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Sue_H SSC Guru Points: 90860 More actions · Answer 4

Think they may have been added in a service pack for both 2012 and 2014 -
Improved memory grant diagnostics when you use DMV in SQL Server 2012 and 2014

Sue

Ed Wagner SSC Guru Points: 287024 More actions · Answer 5

Henrico Bekker - Monday, March 27, 2017 6:52 AM
DesNorton - Sunday, March 26, 2017 10:22 PM
Well, the documentation states that these new columns were added from SQL 2016. However, they are available in my SQL 2014 instance.
SELECT @@VERSION;
Microsoft SQL Server 2014 (SP2-GDR) (KB3194714) - 12.0.5203.0 (X64) Sep 23 2016 18:13:56 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
select total_dop , total_reserved_threads , total_grant_kb from sys.dm_exec_query_stats;
total_dop total_reserved_threads total_grant_kb 3 0 3072 1 0 1872 1 0 1024
That is quite interesting. Thanks for sharing.

They're also present in SQL 2012 SP3.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 6

Seems MS documentation needs to be updated.
Apologies if anyone lost points! 🙂

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

Henrico Bekker - Monday, March 27, 2017 4:12 PM
Seems MS documentation needs to be updated.

Huge understatement

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

Ed Wagner SSC Guru Points: 287024 More actions · Answer 8

SQLRNNR - Monday, March 27, 2017 6:06 PM
Henrico Bekker - Monday, March 27, 2017 4:12 PM
Seems MS documentation needs to be updated.
Huge understatement

Heh - more than just that page needs to be updated. 😉

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions