The following SQL Server System stored Procedures provide a Powerful alternative for many monitoring tasks:
- Sp_who : Reports snapshot information about current SQL Server users and processes, including the currently executing statement and whether the statement is blocked.
2. sp_lock: Reports snapshot information about locks , including the object ID, indexID,type of lock, and type or resource to which the lock applies.
3) Sp_Spaceused : Displays an estimate of the current amount of disk space used by a table .
4) Sp_Monitor : Displays statistics, including CPU usage , I/O Usage, and the amount of time idls since sp_Monitor was last executed.