Share via

QueryTraceOn SQL 2016 to replace 9204

Mark Gordon 916 Reputation points
2021-07-23T12:30:47.033+00:00

Fellow DBA's

I am trying to research what statistics a query is using. I am on SQL 2016

I realized that 9204 is for older versions. Some writings indicate that 9204 has been replaced by 2363.
When I run with options 3604 and 2363 and recompile, I do get output about stats but no where in that mess is the name of the statistics that are being used.

What am I missing?

thx

MG

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,803 questions
0 comments
Accepted answer
  1. Mark Gordon 916 Reputation points
    2021-07-23T14:52:39.083+00:00

    sorry folks,

    Found it, It shows the stats ID number, then you go find which stats ties to that number.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.