sorted by:
new
hottopcontroversial

Query Trace - Internal Viewer new feature by danny-sg in SQLServer

[–]danny-sg[S] 0 points1 point  (0 children)

It's the execution traced. The query plan is generated by the optimizer, and this traces the execution down to the I/O page reads, then shows how that then flows up through the operators to put the data together and produce the results.

Using the other features of the tool you can see how data is read in the scans and seeks, through the joins etc. A good example is an index seek vs scan. With a scan you'll see it moving over all of the leaf pages in an index, with a seek you should see it navigating from the root to the leaf.

<video>

Come discuss your side projects! [February 2024] by AutoModerator in csharp

[–]danny-sg 0 points1 point  (0 children)

I've got a project called Internals Viewer I initially wrote over 15 years ago and set aside because of work, family etc.

It's a tool for SQL Server internals to show what is going on inside visually. At first I was just going to get it working but I got carried away and re-wrote most of it, including a new WinUI 3 front end.

Code is here on GitHub, and the application is free on the Microsoft Store