10 Most Important handy system stored Procedures for DBA
This blog contains the most important system stored procedures which are supported by SQL Server and are used on a daily basis by DBA. These stored procedures are used commonly for maintenance of the server instance.
It provides information about the databases as mentioned in picture below. If any specific database is specified with this command then the information will be displayed about only that database.
It provides information about current users, sessions, and processes in an instance of the Microsoft SQL Server Database Engine.
It displays the disk space reserved and used by the whole database (any specific database).
It shows the database information for all databases on an instance of a server as below.
This stored procedure returns a list of attribute names and matching values for SQL Server.
It displays the information about the tables, name and type etc.
It reports information about locks.
It displays statistics about Microsoft SQL Server.
It runs UPDATE STATISTICS against all user-defined and internal tables in the current database.
It displays or changes global configuration settings for the current server.
Remarks: For more information and more stored procedures, please review Microsoft Blog. It is recommended to execute these stored procedures and see the results in detail which will be beneficial.