The SQL Internals Viewer

  • Comments posted here are about the content posted at

  • One word: OUTSTANDING!

    * Noel

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




    -- Cory

  • 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)


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


    Odds_And_Ends Blog

  • Donavon,

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


  • 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.

  • This is awesome.

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

  • 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]

  • 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]

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


  • 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.



  • 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

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

  • 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 14 (of 14 total)

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