dbWarden - A Free SQL Server Monitoring Package

Question

Post reply

dbWarden - A Free SQL Server Monitoring Package

Stevie Rounds

SSC-Addicted

Points: 452
More actions
April 11, 2013 at 8:02 pm

#276439

Comments posted to this topic are about the item dbWarden - A Free SQL Server Monitoring Package

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

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

jamesHuang SSC Journeyman Points: 87 More actions · Answer 1

Stevie and Michael,

Sorry! I want to give five stars but when I click the star the page submitted!!

:blush:

You are my heroes!!

Regards

James

Stevie Rounds SSC-Addicted Points: 452 More actions · Answer 2

Stevie Rounds

SSC-Addicted

Points: 452

April 11, 2013 at 10:16 pm

#1605850

We are glad you like it!

alchemistmatt Mr or Mrs. 500 Points: 525 More actions · Answer 3

This looks interesting; thanks for sharing. I downloaded the script from Sourceforge and I see you define and populate field Reindex in the DatabaseSettings settings table. Although this field is mentioned in the data dictionary, I don't see any code that examines this switch to determine whether or not to do something. What am I missing? I already have Sql Server agent jobs in place to re-index, so I don't need indexing enabled, but I wanted to help you improve your script.

Matt

Stevie Rounds SSC-Addicted Points: 452 More actions · Answer 4

The reindex is a work in progress feature. We mention that in the article. It actually looks like we have the following text twice, 🙂 oops. Thanks!

*There is also a flag in the DatabaseSettings table for Reindexing. This is a work in progress feature. We created a wrapper proc for Ola Hallengren’s reindex/defrag script to look at this table to determine if a database should be skipped during reindex/defrag. We have not included the wrapper proc in the DBWarden script as of yet.

alchemistmatt Mr or Mrs. 500 Points: 525 More actions · Answer 5

I haven't run the code yet, but, as far as I can tell, you populate table DatabaseSettings with all DBs with dbid > 4, by default enabling all of the options, then you disable the options only for the databases that match WHERE [DBName] IN ('CHANGEME')".

Personally, I think you should add all of the databases but disable the settings by default (thus "name, 0,0,0,0") , then enable the options for the databases defined in the ChangeMe clause.

Stevie Rounds SSC-Addicted Points: 452 More actions · Answer 6

Thanks. That is a good idea about the DatabaseSettings defaulting to 0... My husband and I had that same conversation last week, but haven't changed it yet.

Paul Brewer SSCrazy Points: 2955 More actions · Answer 7

You have to take your hat off here to RedGate and SQLServerCentral. They develop monitoring tools but are happy to publish free, but less feature rich, alternatives on their website!

Divine Flame SSCoach Points: 15943 More actions · Answer 8

This is some excellent piece of work Steve & Michael! Thank you for sharing this with the community :-).

Sujeet Singh

gsc_dba SSCertifiable Points: 5407 More actions · Answer 9

Awesome script, I had most of these in separate scripts and now have a combined solution - thanks! 🙂

I did get one error, and fixed it by with this:

IF OBJECT_ID('tempdb..#tempdates') IS NOT NULL

BEGIN

DROP TABLE #TEMPDATES

END

I think one of the conditional checks did not create the table so wasnt able to drop it.

gsc_dba

mipe10 SSC Enthusiast Points: 106 More actions · Answer 10

Hi,

Great tool!

I would just like to mentione that it will not work on sql server 2012 since some column names have changed in for example sys.dm_os_sys_info. There are other places as well.

I ran the setup on SQL 2012 + SP1

Regards

marcel.eppel SSC Enthusiast Points: 161 More actions · Answer 11

To get the total volume space of a HDD you might find this link useful:

http://www.sqlservercentral.com/articles/powershell/68011/

It can be done using PowerShell to collect the data in in SQLAgentJob.

The Problem with other solutions found here on the platform is that high security permissions on the server for running extended commands are needed to run.

Jim Murphy SSCertifiable Points: 6263 More actions · Answer 12

I think this is a great idea and I am glad you are sharing with the community. I also really enjoy the integration and using other free and very robust scripts, like from Adam and Ola.

I may have a few interesting scripts that I can send your way (over time as I get a chance) to capture some other interesting things as well.

Oh - look at the Glenn Berry DMV scripts! Free and juicy.

Thanks for your hard work and thought!

Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph

ahperez SSC Eights! Points: 962 More actions · Answer 13

Thanks for posting this script. A lot of work and thought went into this. Lots of us are on shoestring budgets.

Bert De Haes Hall of Fame Points: 3092 More actions · Answer 14

Awesome script, thanks a lot.

I wanted to try this on my server, but failed because my server uses collation 'Latin1_General_bin' ( case sensitive => also for object names ).

I changed the script and now it seems to work.