RE:[sap-basis] Deadlock Problem - SAP and SQL SERVER
Posted by
Admin at
|
Share this post:
|
|
0 Comments
Posted by USER_1631058on 07/12/2009 10:53:00 PM
DBCC TRACEON(1222,-1) -- Writes deadlock events, T-SQL used, deadlock, deadlock victims, etc.. to the SQL Server logs
DBCC TRACESTATUS(-1) --Gives global status of traces
DBCC TRACEOFF(1222,-1) --Turns the trace off since the SQL logs can get large very quickly. __.____._
Copyright © 2009 CEB Toolbox, Inc. and message author.
Toolbox.com
4343 N. Scottsdale Road
Suite 280
Scottsdale, AZ 85251
Toolbox.com
4343 N. Scottsdale Road
Suite 280
Scottsdale, AZ 85251
Related Content
In the Spotlight
White Papers
In the Spotlight
SAP Enterprise Software: flexible, best-of-breed business apps View Vendor Profile
View this post online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
