Post reply

The SQL Internals Viewer

  • August 20, 2007 at 4:29 pm

    #373289

    Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/dgould/3200.asp

  • August 27, 2007 at 7:33 am

    #729523

    One word: OUTSTANDING!


    * Noel

  • August 27, 2007 at 7:35 am

    #729524

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

    THANKS!

     

    C

    -- Cory

  • August 27, 2007 at 8:01 am

    #729533

    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)

     

  • August 27, 2007 at 8:18 am

    #729545

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



    --------------------------
    Zach

    Odds_And_Ends Blog

  • August 27, 2007 at 8:26 am

    #729551

    Donavon,

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

    Danny

  • August 27, 2007 at 10:07 am

    #729591

    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.

  • August 27, 2007 at 10:46 am

    #729596

    This is awesome.

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

  • August 27, 2007 at 10:49 am

    #729597

    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 issues@sqlinternalsviewer.com to help improve this application.

    ------------------------------

    ADDITIONAL INFORMATION:

    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]

  • August 28, 2007 at 9:58 am

    #729828

    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]

  • August 28, 2007 at 12:21 pm

    #729886

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

    Danny

  • August 28, 2007 at 5:30 pm

    #729952

    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.

    Thanks,

    Shane

  • September 10, 2007 at 11:03 am

    #732558

    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

  • September 10, 2007 at 11:15 am

    #732560

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

  • September 10, 2007 at 11:19 am

    #732564

    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