DBCC 1204

How do i execute DBCC 1204 and where do i look for the results.

Please advice.

Thanks.
crishna1Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
arbertConnect With a Mentor Commented:
This is a traceflag that was previously documented, but was left undocumented in SQL2000--I wouldn't use it.

You can obtain pretty much the same information by executing SP_WHO in query analyzer to find the blocking process.  You can then see what the process is running by execute DBCC INPUTBUFFER(processidhere)

Brett
0
 
crishna1Author Commented:
I am trying to moniter the locks/tableloacks/deadlocks.
0
 
ChrisFretwellConnect With a Mentor Commented:
Actually, it is documented in sql 2000, at least its in books online if you search for "Troubleshooting Deadlocks" in the index, it gives information on how to use dbcc 1204 and where else to look in BOL for help to interpet it. (deadlocks involving locks, deadlocks involving paralellism and deadlocks involving thread).

You can also use performance monitor to help and again books online is a great place to look for specific information on how to track it that way.


0
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

 
arbertCommented:
Weird, it wasn't suppose to be a documented function.  Maybe they added it in a later BOL....
0
 
ChrisFretwellCommented:
There was a BOL update in January I think (maybe late December) You can download it from MS, not a small file, but obviously a handy one.  I can hunt down the link if you need it.

It has only 4 trace flags defined 260,1204,2528 and 3205.

Chris
0
 
arbertCommented:
Nope, I got the current--just didn't look.  I knew from past information it wasn't "suppose" to be documented.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.