SQL Server Instance in Run Time

SELECT @@CONNECTIONS 'CONNECTIONS'

SELECT @@CPU_BUSY 'CPU_BUSY'

SELECT @@CURSOR_ROWS 'CURSOR_ROWS'

SELECT @@DATEFIRST 'DATEFIRST'

SELECT @@DBTS 'DBTS'

SELECT @@DEF_SORTORDER_ID 'DEF_SORTORDER_ID'

SELECT @@DEFAULT_LANGID 'DEFAULT_LANGID'

SELECT @@ERROR 'ERROR'

SELECT @@FETCH_STATUS 'FETCH_STATUS'

SELECT @@IDENTITY 'IDENTITY'

SELECT @@IDLE 'IDLE'

SELECT @@IO_BUSY 'IO_BUSY'

SELECT @@LANGID 'LANGID'

SELECT @@LANGUAGE 'LANGUAGE'

SELECT @@LOCK_TIMEOUT 'LOCK_TIMEOUT'

SELECT @@MAX_CONNECTIONS 'MAX_CONNECTIONS'

SELECT @@MAX_PRECISION 'MAX_PRECISION'

SELECT @@MICROSOFTVERSION 'MICROSOFTVERSION'

SELECT @@NESTLEVEL 'NESTLEVEL'

SELECT @@OPTIONS 'OPTIONS'

SELECT @@PACK_RECEIVED 'PACK_RECEIVED'

SELECT @@PACK_SENT 'PACK_SENT'

SELECT @@PACKET_ERRORS 'PACKET_ERRORS'

SELECT @@PROCID 'PROCID'

SELECT @@REMSERVER 'REMSERVER'

SELECT @@ROWCOUNT 'ROWCOUNT'

SELECT @@SERVERNAME 'SERVERNAME'

SELECT @@SERVICENAME 'SERVICENAME'

SELECT @@SPID 'SPID'

SELECT @@TEXTSIZE 'TEXTSIZE'

SELECT @@TIMETICKS 'TIMETICKS'

SELECT @@TOTAL_ERRORS 'TOTAL_ERRORS'

SELECT @@TOTAL_READ 'TOTAL_READ'

SELECT @@TOTAL_WRITE 'TOTAL_WRITE'

SELECT @@TRANCOUNT 'TRANCOUNT'

SELECT @@VERSION 'VERSION'