Programmer's Stack
Pages
Home
ChannelJava
JQuery
My Tasks App
Bootstrap Templates
Selenium
Java For Beginners
{{theTime}}
!doctype>
Search This Blog
Total Pageviews
Enable Trace Flag 1024, 1222 to detect deadlocks in msssql server
How to enable trace flag 1024, 1222 to log the deadlock sql's to the error log.
DBCC TRACEON (1024,1222)
Turn off dead lock trace flag
DBCC TRACEOFF (1024,1222)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
How to install Windows Subsystem for Linux?
- Open Powershell in Admin mode and run wsl --install
No comments:
Post a Comment