I am hoping someone can help me understand how to deal with this alert I have just recently been getting from my server.
I've been reading some blogs, and I can see that this occurs when memory maybe over committed.
This has been happening on my machine over the past week only.
And always around the same time.
In most instances page count is below 2000 but on two occasions it was just above 10k.
I've taken a list of times when these emails occur, and i'm going to check out all the jobs running at that time. They are all in the early AM - so usually our replication processes are in full swing.
The server itself, should not be used by anyone else at that time, its only processing data, there may be some calls to the report server with timed subscriptions, but on second thoughts there would be none set up even at that time.
What I would like some advice on is knowing where to look from here? how do I know what is causing this? What database/ job/ process.
using Sql Server 2005. x64
Intel(R) Xeon(TM) CPU 3.40GHz
3.39 GHz, 31.9GB of Ram