OK,

I've done it and have the logs.

What should I check?

I can see the following but not sure if it's relevant

TxDataCollector!1250!25ec!2015/05/13!13:54:57:: ...

Hi again,

I've just tried increasing the logging of the collectors using the below query

update msdb.dbo.syscollector_collection_sets

set logging level = 2

where collection_set_id = 3

and when ran, it returned me dozens of warnings...

Hi Gianluca,

Thanks again for your help

I ran your queries (sorry for the delay I'm on Australian time 🙂 )

The Monitored server query looks ok, I get the CacheWindow at 1,...

Done

the topic is there http://www.sqlservercentral.com/Forums/Topic1684348-3411-1.aspx

Thanks for the reply (and the advice 🙂 )

Hi guys

I'm reaching out because I think I reached my limits and I have no idea of what's happening

I'm trying to setup a MDW to monitor our company's test servers...

One of the first thing I would check is the "power options" configuration of the server.

It has to be set to high performance to allow the server to fully use...

Hi Dave,

I've just started experiencing the same problem that the one you're describing.

And funnily enough it started this week too.

I am using lots of sequences as default constraint in our...

Yeah I used such function a lot in our applications although it is nice to have the ability to call with different delimiters (sometimes people don't like to use commas...