My Favorite SQL Server System Views and Tables

Built into SQL Server are a growing set of exceptionally useful system views and tables that provide insight into many server and database components.

This demo-heavy session provides a wide array of queries and tools that can leverage system data to understand how different systems work, including:
Wait stats
Windows/System info
Performance counters
Index/Columnstore index structure
Registry entries
Database files, size, and metadata
Query stats
...and more!

Using these tools, database maintenance can be better automated and validated and application and analytics code can make smarter use of system metadata when making important processing decisions.

These are my favorite applications of system data for you to enjoy!

Edward Pollack

Data Architect | Microsoft Data Platform MVP

Albany, New York, United States


Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top