Anatomy of SQL Server end article about Internals Viewer source code

Original: Anatomy of SQL Server end article about Internals Viewer source code

Anatomy of SQL Server end article about Internals Viewer source code

You may have used the Internals viewer software.

Widget for viewing SQL Server Internal Data page Internals Viewer

But don't know how many people have seen his source code?

The author put the source code on the CodePlex website, but this source code only supports SQL2008 and below, does not support SQL2008R2

Later, someone based on the original author's code to write the SQL2008R2 version, called "Internals Viewer (updated) for SQL Server R2."

I downloaded both the first and second versions of the source code.

Code download

First edition: Http://files.cnblogs.com/lyhabc/internalsviewer1.rar

Second Edition: Http://files.cnblogs.com/lyhabc/intview2.rar

Project Address

First edition: http://internalsviewer.codeplex.com/

Second Edition: https://intview2.codeplex.com/

Internals Viewer first Edition source code

Before looking at the source code, I think you should take a look at the comments above CodePlex to find bugs and bugs in the software

And the changes in each version.

In the solution, the SSMs plug-in project and UI project can be ignored directly if you only want to study the core code

For transaction logs, there are only three classes in the project: Logdata class, LogMonitor class, Logsequencenumber class

You can study it with the Technical Insider's book.

Data compression related classes, which may be difficult to understand due to the small number of annotations

Sparse columns

Pre-turn record

Nonclustered index RID Address

Internals Viewer Second Edition source code here, let's call him second edition.

In the second edition because the popularity is inferior to the first edition, Nature basically does not have many people to know, also has no comment and the bug feedback

The second version of the structure and the document is basically the same as the first version, but some places different

This is no longer an introduction, you can compare with the comparison tool

This series has been written, but the task is not over, SQL Server is a very large software, basically proficient in SQL Server is very difficult

Hope crossing like this series of articles O (∩_∩) o

Anatomy of SQL Server end article about Internals Viewer source code