degree of parallelism in sql server 2000

Hi,

I would like to know how can I see the degree of
parallelism for select,insert,delete statements. I am on
SQL 2000 , I check SQL profiler , Performance event
class , It has got 1,2,3,4 degree of parallelism to
monitor degree but it says (7.0 delete, insert, select,
update)

what is the way to monitor Degree of Parallelism for SQL
server 2000. like to see if query is running in Parallel or not .

Please let me know.

Thanks,
Sac.YOu can use PROFILER to monitor degree of parallelism. For information refer to SQL Performance (http://www.sql-server-performance.com) website for articles and tips.