Most useful stored procedures for a new DBA? 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


Useful system stored procedures in SQL Server(SO)
Two Dozen of My Favorite System Stored Procedures, By Kiely, Don


What are the best or most helpful Stored Procedures for a New DBA to have in their tool kit, for SQL 2012/2014?
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 ...


Brent Ozar Crew has sp_Blitz®, sp_BlitzCache®, sp_BlitzIndex®, sp_AskBrent®, sp_BlitzRS™, sp_BlitzTrace™ - This helps to do health check for sql servers.
To migrate sql server from one server to another use powershell - dbatools [it migrates over 25 components] from Chrissy LeMaire
To document sql server use - SQL Power Doc from kendalvandyke
For login transfer use Transferring Logins - By SQLSoldier 
Monitoring SQL Server use sp_whoisactive from Adam Machanic
Analyzing Query plans - use SQL Sentry's Free Plan Explorer


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 &lt;-- 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