Results 1 to 2 of 2

Thread: Finding MAXDOP used by queries

  1. #1
    Join Date
    Aug 2009
    Posts
    23

    Finding MAXDOP used by queries

    Hello,

    We have sharepoint databases running on our SQL server 2008 instance. Apart from Sharepoint there are many other databases running on the same SQL 2008 instance. Actually the requirement for Sharepoint application is such that the degree of parallelism must be set to 1. But we were facing some problem with other databases and we concluded that setting MAXDOP=0 would solve the problem for other databases.

    Now what we have done is, We have set the MAXDOP=0 at instance level and configured resource governor with MAXDOP=1 workload group setting for sharepoint application to use.

    My question is, Is there a way (by using DMVs or profiler or something else) to check whether the queries originating from sharepoint are, actually, using MAXDOP=1. It is working fine as of now but there needs to be a proof that sharepoint queries are using MAXDOP=1 setting in resource governor.

    Thanks in advance!!

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Can try with sys.dm_exec_query_optimizer_info and sys.dm_exec_requests.

Posting Permissions

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