November 6, 2015 at 6:19 am
Hi all,
I've installed the MDW (Mangement Data Warehouse) database on our central monitoring SQL Server. I've then added a number of servers to be monitored. The data is collected on the servers that are being monitored and uploaded to the central MDW Monitoring server.
On the servers that are being monitored, I'm seeing a large number (over 1000) of SPIDs being generated by 'SQL Server Data Collector'.
Is this normal behaviour? I've seen more blocking as a result of this.
Is there any way to reduce the number of SPIDs generated?
Thanks,
Ranvir
November 9, 2015 at 2:08 am
Hey,
How often are you collecting the stats?
November 10, 2015 at 2:37 am
The data collector is running continuously and it is being uploaded to the monitoring server every 15 minutes.
November 10, 2015 at 2:43 am
What are the wait types for all the SPIDS?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply