Introduction

There are a few system statistical functions, stored procedures, and DBCC commands that can be useful while analysing performance-related issues. However, even though most of the statistical information that these commands provide can be retrieved by using dynamic management views and dynamic management functions, many database professionals use these features because they have been a part of SQL Server for a long time and are popular and handy while monitoring and looking into performance-related statistics.

You would often use these commands in real life as a quick tool to check the health of the server and the status of SQL Server processes.