How to Get SQL Server Statistics Information Using System Statistical Functions

Often, we need to gather system statistics regarding running SQL Server Instances, such as the number of total connections attempted to SQL Server instance since its start, or the time that SQL Server spent in active operations, etc. Microsoft brought us a separate set of system functions to retrieve the system-related statistics.  Today, I am going to explain such system statistical functions with the use cases.

CodingSight - Get SQL Server Statistics Information using System Statistical Functions
Read More