Question on DMVstats

May 20, 2008 at 4:18 PM
Hi,

I have the following questions on DMVStats:

1.  If I configure DMVstats to collect data only for a specific database, will it still continue to collect data for all the databases?

Reason:  When I look for the data related to different waits(Like I/O etc), it is showing the data even for the DMVStats database which is not added to the list of configured databases.

2.  When I look at the resource waits graph, I see that there was lot of waiting for service broker.  There is nothing on sql server which makes use of service broker. 


Please advice.  Your help is highly appreciated.

-Shiva