Scripts and stored procedures for Microsoft SQL Server Database Administrators
Quick overview of stored procedures:
ScriptLoginPermissions – scripts server-level and database-level permissions, role memberships for specified login
ShowTableUsage - shows which tables are used (inserts,updates,deletes,locks,scans, etc.) within a database, and which are not
ViewServerProperties – shows number of physical and logical cores, sockets, memory, host OS info, server machine info, SQL instance-level properties and configuration options, and more
MemoryManagerInfo – shows how SQL Server is using memory
BufferPoolSize – break down of the Buffer Pool
ServerSpaceUsage – shows how much storage space SQL Server instance consumes, and details for files and their fullness
DatabaseSpaceUsage – help DBA quickly identify which tables are the largest in a specified database, and table/index/reserved/free space in the database
TempDBInfo – shows detailed information on current state of TempDB database
ViewSessionsConnections – use this to learn details about sessions connected to your system
Detailed instructions:
Hope you will find tools useful!