EXERCISE 13.2MONITOR DEADLOCKSTHIS EXERCISE WILL DEMONSTRATE HOW TO EN...

10. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P120 PPTX
THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P120 PPTX

10. restart the sQL server service for the trace flag to take effect.

To view the output of the traceflag—that is, to monitor whether any

deadlocks have occurred: