Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    94

    Unanswered: 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.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    YOu can use PROFILER to monitor degree of parallelism. For information refer to SQL Performance website for articles and tips.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •