Improvements for troubleshooting are in the latest service pack for SQL Server 2012.
Applying service pack 3 for SQL Server 2012 means that the query statistics DMV (dm_exec_query_stats) will now report on memory grant, parallelism and thread information.
For a full list of new columns and further information look here: https://support.microsoft.com/en-us/kb/3107398
More information on the service pack can be found here: http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/11/24/sql-server-2012-service-pack-3-is-now-available.aspx
No comments:
Post a Comment