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.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHy3I_TvhUvoOKsiCWJLZCoKL20ACm1owclH4fIWQGbfjvGztRaG153vdGhxALKMlE-9rEm5c98inorT3OtCs5DBAZFtY52lf7J909w7YoQvey9OZdzDBCqFryNPpqBFduezwW/s320/SQLInternalsViewer.jpg)
More details on: http://www.sqlinternalsviewer.com/
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