DBCC OPENTRAN is used to identify the active transactions that may preventing the log truncation. DBCC OPENTRAN displays information about the oldest active transaction and oldest distributed and non distributed replicated transactions.
The DBCC INPUT BUFFER comes under the information statements category of the DBCC commands. The DBCC INPUT BUFFER Command gives the last request from the client to the instance.
What are DBCC Commands?
The DBCC commands acts as a Database Console commands for SQL Server. The DBCC commands are categorized into four.
||Maintenance task on database,index & Filegroups
||Miscellaneous tasks such as enabling trace flags or disabling a DLL from memory
||Task that gather and display various types of information.
||Validation Operation on database,table,index, filegroup or allocation of database pages.
The DBCC commands and examples will be continued.