Anyone know where the MS Auditing tool is?

Question

Anyone know where the MS Auditing tool is?

blacklabellover2003

SSC Eights!

Points: 875
More actions
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.

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

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

blacklabellover2003 SSC Eights! Points: 875 More actions · Answer 2

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?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

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

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 4

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

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 5

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)

Leonard Rutkowski SSCrazy Points: 2668 More actions · Answer 6

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.