SQL Server stored procedures and commands

The items in this section can be used to return information related to performance.
Note: This topic applies only to on-premises environments.
  • sp_who and sp_who2 - The stored procedure sp_who shows what SPID is blocked. sp_who2 shows who is blocking.
  • sp_helpindex (table_name) - Gives index information on a table.
  • DBCC OPENTRAN - Determines whether an open transaction exists within the log.
  • DBCC INPUTBUFFER (SPID) - Displays the last statement sent from a client to SQL Server.
  • DBCC Trace On - Enables specified trace flags.
Related topics