3

I am a new DBA working with several more experienced DBA's. When I am scratching my head one of them says "oh just run SP_xx_xx", and sure enough that begins the path to solution.

Of course they all just know them, I have decided to start a list. I have not been writting them all down, so all I have in my list is these three.

  • sp_Cycle_Errorlog
  • sp_whoisactive
  • sp_change_users_login 'report'

I Googled and came up with some very old lists

What are the best or most helpful Stored Procedures for a New DBA to have in their tool kit, for SQL 2012/2014?

9

What are the best or most helpful Stored Procedures for a New DBA to have in their tool kit, for SQL 2012/2014?

You are asking Tools that are most useful to DBA

In no particuliar order ...

The inbuild system SP are limited to what they can report or show. The best way is to create your own (use existing ones and build your own <-- make sure you give proper credit ! ) using DMVs.

e.g. sp_who is way ancient vs sp_whoisactive is what you will install on your server to quickly findout whats going on with the server.

Remove sp_change_users_login 'report' as it is deprecated. Instead you should use ALTER USER

| improve this answer | |

Not the answer you're looking for? Browse other questions tagged or ask your own question.