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!!