SQL Internals Viewer is a tool for looking into the SQL Server storage engine and seeing how data is physically allocated, organised and stored.
All sorts of tasks performed by a DBA or developer can benefit greatly from knowledge of what the storage engine is doing and how it works. This tool has been designed to make database internals more accessible.
A Quick Start Video:
http://www.sqlinternalsviewer.com/Guides/allocation_map.html
For example you can see IAM (Index Allocation Map) for a specific index or the Allocation Map for a table.
More details on: http://www.sqlinternalsviewer.com/
- Blogger Comment
- Facebook Comment
Subscribe to:
Post Comments
(
Atom
)
1 commenti:
That's cool, SQL Internals Viewer is a tool for looking into the SQL Server storage engine and seeing how data is physically allocated, organised and stored you can get more about programming from this.
http://www.cyberdesignz.com/
Post a Comment