Monitoring SQL  «Prev  Next»

Summary SQL Functions

Summary SQL @@functions


How many attempted logins have there been since SQL Server was last booted? @@CONNECTIONS
How long has SQL Server been using the CPU since startup? @CPU_BUSY
Has there been any period of time that SQL Server has not been working since startup? @@IDLE
What is the highest number of simultaneous connections since SQL Server last started? @@MAX_CONNECTIONS
How many network packet errors have there been? @@PACKET_ERRORS
How many network packets have been received since it last started? @@PACK_RECEIVED
How many network packets have been sent? @@PACK_SENT
What is the SQL Server’s name? @@SERVERNAME
What registry key was used when starting SQL Server? @@SERVICENAME
How many network packets have been sent? @@PACK_SENT
How many milliseconds per clock tick? @@TIMETICKS
How many disk I/O errors have there been since SQL Server started? @@TOTAL_ERRORS