System Statistical Functions, Stored Procedures, and the DBCC SQLPERF Command - Microsoft SQL Server 2012 Performance Tuning - page 60

,TotalPhysicalReadOperations
,TotalWriteOperations
,TotalReadWriteErrors
)
SELECT
@@CONNECTIONS AS TotalConnections
,@@TIMETICKS AS TimeTicks
,@@CPU_BUSY AS TotalCPUBusyTime
,@@IDLE AS TotalCPUIdleTime
,@@IO_BUSY AS TotalIOBusyTime
,@@PACK_RECEIVED AS TotalReceivedPackets
,@@PACK_SENT AS TotalSentPackets
,@@PACKET_ERRORS AS TotalErrorsInNetworkPackets
,@@TOTAL_READ AS TotalPhysicalReadOperations
,@@TOTAL_WRITE AS TotalWriteOperations
,@@TOTAL_ERRORS AS TotalReadWriteErrors

GO

3. Next, run the query, as shown in the following script, to display the collected server

health statistics data:
--Display the collected server health
--statistics data.
WITH cteStatistics AS
(
SELECT
ID
,StatDateTime
,TotalConnections
,TotalCPUBusyTime*CAST(TimeTicks AS BIGINT)
AS TotalCPUBusyTime
,TotalCPUIdleTime*CAST(TimeTicks AS BIGINT)
AS TotalCPUIdleTime
,TotalIOBusyTime*CAST(TimeTicks AS BIGINT)
AS TotalIOBusyTime
,TotalReceivedPackets
,TotalSentPackets
,TotalErrorsInNetworkPackets
,TotalPhysicalReadOperations
,TotalWriteOperations
,TotalReadWriteErrors
FROM [dbo].[tbl_ServerHealthStatistics]
)
SELECT