March 30, 2010 at 7:16 am
Hi all
I noticed in task manager that sqlservr.exe looked to be hogging memory so I ran some perfmon counters and got th following:
Buffer Cache Hit Ratio: Avg. Value 99.82
Pages\Sec: Avg. Value 22.75
Available Bytes: Avg. value 114758800 which equates to about 0.1Gb
As our machine has 16Gig memory in it this says to me SQL is using is hogging all the server resources, but my question now is how do i tell in SQL what is actually causing the issue? Should I start to tweak the Max Server Memory option?
Thanks
March 30, 2010 at 12:03 pm
What is max server memory set to at the moment?
Which edition of SQL Server are you running?
32 or 64 bit?
Is the server dedicated to SQL Server, or are there other applications running?
March 31, 2010 at 5:00 am
Paul White NZ (3/30/2010)
What is max server memory set to at the moment?Which edition of SQL Server are you running?
32 or 64 bit?
Is the server dedicated to SQL Server, or are there other applications running?
Hi Paul
Its SQL 2005 Enterprise 64bit, and there a various clients running on the machine as well as SQL.
March 31, 2010 at 6:10 am
Kwisatz78 (3/31/2010)
Its SQL 2005 Enterprise 64bit, and there a various clients running on the machine as well as SQL.
Ok, so maybe start off conservatively with a max server memory setting equivalent to, say, 12GB.
Let the system reach steady-state, and review it again.
Many people are comfortable leaving 1-2GB free to cope with any sudden demands, but it depends on your environment.
March 31, 2010 at 8:13 am
Ok that seems seinsible I will try that.
Thanks
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply