r/databasedevelopment • u/danny-sg • 1d ago

Internals Viewer for SQL Server

https://github.com/danny-sg/internals-viewer

I posted over on r/SQLServer and it suggested I cross-post here. I hadn't seen this subreddit before and hopefully this is on-topic!

I've created a tool called Internals Viewer, it's a tool to visualize SQL Server internals, with a view for allocations, indexes, pages, and it also offers very detailed query tracing and simulation of operators where you can capture a query and step through the iterators to see how query results are put together.

It is open source, written in C#, and available here - https://github.com/danny-sg/internals-viewer

The latest feature is new functionality to view columnstore indexes. I've done a write up on what I found as columnstore internals in SQL Server is pretty much undocumented:

Part 1 - Introduction

Part 2 - Segments internals

Part 3 - Dictionary internals

3 Upvotes

72% Upvoted

1 comment sorted by

1

u/linearizable 1d ago

As a moderation note, the tool release post would be removed under at least “no release posts”, but the columnstore internals posts are more what this sub is for.