The SQL Internals Viewer

  • Danny Gould-360568

    SSC Journeyman

    Points: 92

    Comments posted here are about the content posted at

  • noeld

    SSC Guru

    Points: 96590

    One word: OUTSTANDING!

    * Noel

  • Cory E.


    Points: 7076

    This looks really, I need to understand what infomation I have here...still looking.




    -- Cory

  • Jones'e

    Right there with Babe

    Points: 744

    Looks great.

    When I try to connect to a remote db, I get this error:

    Any one know why?

    TITLE: Connect to server


    Invalid object name 'sys.database_files'. (Microsoft SQL Server, Error: 208)


  • Zach Nichter

    Mr or Mrs. 500

    Points: 547

    I'll be checking this app out.  It looks great!


    Odds_And_Ends Blog

  • Danny Gould-360568

    SSC Journeyman

    Points: 92


    What version of SQL Server are you trying to connect to? The tool only works with SQL Server 2005/2008.


  • David McFarland


    Points: 11815

    This is sweet. No more DBCC Page commands for me!

    As an aside, does Kalen Delaney know about this tool yet? She might find it quite interesting, since she's person that many of us learned the internals from in the first place.

  • Aaron Ingold

    SSCrazy Eights

    Points: 9070

    This is awesome.

    Great tool. I'm adding this to my shortlist of must have SQL Server tools.

  • Robert Davis

    One Orange Chip

    Points: 28027

    A couple of changes that I'd like to see made in the tool in a future release:

    1. The application is listed as ".Net SqlClient Data Provider". Would prefer to see it's actual application name listed when I do an sp_who2.
    2. The distribution database is listed as a user database rather than a system database. I would like to see it listed as a system database.


    I received the following error:

    TITLE: SQL Internals Viewer


    An unhandled exception has occurred.

    Please report this error to to help improve this application.



    Index was outside the bounds of the array. (SqlInternalsViewer)


    Program Location:

       at SqlInternalsViewer.UI.AllocationUnitsLayer.GenerateLayers(Database database, BackgroundWorker worker)

       at SqlInternalsViewer.ApplicationForm.AllocUnitbackgroundWorker_DoWork(Object sender, DoWorkEventArgs e)

       at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)

       at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

  • Wayne West


    Points: 22586

    Is this a Vista-only app? I don't have 2005 online right now to play with it yet, I was wondering because the window control boxes are different.

    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • Danny Gould-360568

    SSC Journeyman

    Points: 92

    The application will run on any OS that supports the .NET Framework 2.0. This includes Windows 2000, 2003, XP, and Vista.


  • Shane Fought

    Valued Member

    Points: 62

    Thanks for the great app and resource page!

    Any idea why some of my SQL Server 2005 DB's show up grey?  They are online and I can query them via Management Studio, but SQL Internals Viewer won't pull up any info on them.



  • Tatsu


    Points: 7824

    I am seeing the "gray" databases as well. One of them is in SQL 2000 (80) compatibility mode and the others used to be but have been changed to SQL 2005 compatibility.

    I am also looking forward to the multi-file support.

    Many thanks Danny!!

    [font="Tahoma"]Bryant E. Byrd, BSSE MCDBA MCAD[/font]
    Business Intelligence Administrator
    MSBI Administration Blog

  • Shane Fought

    Valued Member

    Points: 62

    The reason some of my DB's we're greyed out is because they contain multiple files, which the app doesn't support yet.

  • Tatsu


    Points: 7824

    Thanks Shane! I forgot that I had created some multi-file databases on my development server in preparation for a move to our new production server.

    [font="Tahoma"]Bryant E. Byrd, BSSE MCDBA MCAD[/font]
    Business Intelligence Administrator
    MSBI Administration Blog

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply