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
PutochAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arnoldCommented:
The first thing to check is whether the system is setup as application server (programs have priority in processor and memory.) network adapter setting to prioritize for network applications.

How big have your database/s grown?
0
David ToddSenior DBACommented:
Hi,

What edition(s) of Windows and SQL are you using? Its possible that standard edition of windows is at the max amount of ram for that edition.

Otherwise I'd ask how quickly could you add more ram.

Have you set the max ram for SQL? To what is it set?

Regards
  David
0
David Johnson, CD, MVPOwnerCommented:
Sql Server 2005. x64

What are your SQL Server Memory Settings
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

PutochAuthor Commented:
Thank you all,
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.
0
David ToddSenior DBACommented:
Hi,

What edition of Windows - standard, enterprise ... ?

Regards
  David
0
PutochAuthor Commented:
Sorry , its Enterprise also
0
David ToddSenior DBACommented:
Hi,

Then adding additional ram is an easy option.

Second thing is to find what else is installed on the server, that is using ram. Now not everything that SQL does shows up in task manager, but looking at the processes from all users is a useful first step.

It appears that your SQL max ram is set at a reasonable level. Adjusting it down might help your symptoms some.

Regards
  David
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.