question

@SQLShark avatar image
@SQLShark asked

What should be in a DBA database?

Hi everyone. I often hear DBAs at conferences talk about their "DBA database" where they hold all manner of tables for processes/statistics/baselines etc. I'm not a DBA however I am now managing our DB (SS2012), which has an OLTP application running on it. My question is what sort of processes/activities do you use this "DBA database" for? Thanks in advance.
dbabest-practiceprocess
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
The site works off of votes. If any of the answers below were helpful, indicate this by clicking on the thumbs up next to those answers. If any one answer below lead to a solution, indicate this by clicking on the check box next to that answer.
1 Like 1 ·
@SQLShark avatar image @SQLShark commented ·
Thanks for the reminder Grant - I hadn’t gotten around to doing it yet.
0 Likes 0 ·

2 Answers

·
raadee avatar image
raadee answered
I put the following in my "DBA Database": - [SP_Whoisactive][1] (What's happening on my server) - [SP_Blitz][2] (Diagnose your instance) - [SP_Blitzindex][3] (Diagnose your indexes) - [SP_AskBrent][4] (Log current information/metrics on your server) - [Ola Hallengren maintenance scripts procedures][5] (All backup/maitenance) - Logging Tables, for example when running Profiler or logging SP_whoisactive output. [1]: http://sqlblog.com/blogs/adam_machanic/archive/2012/03/22/released-who-is-active-v11-11.aspx [2]: http://www.brentozar.com/blitz/ [3]: http://www.brentozar.com/blitzindex/ [4]: http://www.brentozar.com/askbrent/ [5]: http://ola.hallengren.com/
3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image sp_lock commented ·
I also use the DBA database as a temp dumping ground for backing up data updates/delete (even though it may not be required, just for my sanity) Just remember to clean up after yourself.
1 Like 1 ·
@SQLShark avatar image @SQLShark commented ·
Thank you Raadee. A few of those I had seen before a few I had not. Ola's looks interesting!
0 Likes 0 ·
raadee avatar image raadee commented ·
You are welcome SQLShark!
0 Likes 0 ·
ThomasRushton avatar image
ThomasRushton answered
In addition to @raadee's suggestions, I would have tally / numbers tables (not just numbers, but also for dates, times etc) to aid more interesting queries. See, for example, [this SQLServerCentral article][1] from the one and only Jeff Moden. [1]: http://www.sqlservercentral.com/articles/T-SQL/62867/
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@SQLShark avatar image @SQLShark commented ·
Thanks Thomas. I will have a look.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.