Post reply

Anyone know where the MS Auditing tool is?

  • September 19, 2010 at 4:49 am

    #157210

    I need to take an inventory of the infrastructure (DB/Server settings, datafile/logfile placements, indexing etc). No budget for a paid tool yet.

  • September 19, 2010 at 5:09 am

    #1223599

    No such free tool that I know of. I wrote a whole bunch of scripts to do such audits. They're not that hard to write, just tedious.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 19, 2010 at 5:20 am

    #1223602

    GilaMonster (9/19/2010)

    No such free tool that I know of. I wrote a whole bunch of scripts to do such audits. They're not that hard to write, just tedious.

    Did you publish them? Or know where I can get hold of other such scripts?

  • September 19, 2010 at 5:54 am

    #1223606

    blacklabellover2003 (9/19/2010)

    GilaMonster (9/19/2010)

    No such free tool that I know of. I wrote a whole bunch of scripts to do such audits. They're not that hard to write, just tedious.

    Did you publish them?

    No. They're for a config analysis service that I offer clients. Publish them and I'm giving away tricks that let me do this kinda work quickly.

    Or know where I can get hold of other such scripts?

    Not offhand. Check the script library here.

    That said, they're not hard to write. Decide what you need to see, then check the documentation and then see which schema views/DMVs hold the info that you want.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 19, 2010 at 1:04 pm

    #1223694

    Please find the attachement. Actually I got the script from the web. I don't remember from where. All credits to tha actual author.

    Thank You,

    Best Regards,

    SQLBuddy

  • September 19, 2010 at 11:03 pm

    #1223795

    I agree... I think that every DBA worth a salt has their own private bag o' tricks in this area especially those good folks (like Gail) that make a living out of that sort of thing. I don't expect you'll find many willing to cough up the code in this area. It's kind of like a Jedi Knight building his/her own light saber and keeping it for life. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • September 21, 2010 at 6:57 am

    #1224760

    Here is a powershell script I use. Rename the attachment to .ps1. Create a .txt file with a list of servers. Update the script to use the .txt file.

Viewing 7 posts - 1 through 6 (of 6 total)

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