SQL 2005 agent - stat collection not working

SQL 2005 agent - stat collection not working

avdvyver 16 Jul 2008 09:22

Hi,

I've noticed that on some of my SQL 2005 DB servers, the data collection that the SQL2005 agent is suppose to do (like DB size collection etc), is not working. The pattern seems to be that if the DB server houses only a few DBs, the stats are collected, but if the DB server has got heaps of DBs (> 200) the stats are not collected. All the DBs shows up in Operation Manger, but I cannot see any data for it in the reports or in the monitoring views. Does anyone know if there is a threshold for the number of database or something similar that needs to be set that will correct the collection?

Thanks!