Useful Transact-SQL commands

  • USE databasename
  • EXEC sp_who
  • EXEC sp_monitor
  • SELECT @@CONNECTIONS AS ‘Connections’
  • SELECT @@TOTAL_READ
  • SELECT @@TOTAL_WRITE
  • SELECT @@TOTAL_ERRORS
Advertisements

Post a Comment

Required fields are marked *
*
*

%d bloggers like this: