OS paging is #### pages/second on Server
Hi there,
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
Thank you,
p
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
Thank you,
p
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry , its Enterprise also
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Just to answer some of your questions;
My SQL Server memory setting is currently: 27000
My windows version is - Microsoft Windows Server 2003 R2 (SP2)
my server version is - MS SQL Server Enterprise Edition 64bit
no major db growth in the last month.