February 3, 2004 at 3:41 am
Hello All,
I've got a SQL Server running on a windows cluster with 2 GB of RAM, the performance monitors indicate that the total RAM utilized is about 97-99 % on a average with a paging file of around 500mb, on further inspection i have noticed that the page faults per second on the SQL server process averages between 8-40 , whereas the clussvc process averages 400-800 page faults a second. what does all this mean , is the SQL process causing the page faults on clussvc or is it because of problems with the cluster service.. Do i need to upgrade the ram or the IO drivers , Sorry don't know too much about admin as am basically a programmer
TIA
February 3, 2004 at 10:45 pm
There is too much memory allocated to SQL Server. You should change the max server memory configuration option to be about 1500 MBytes, so that windows has enough memory to function efficiently.
sp_configure 'max server memory', 1500
go
reconfigure with override
February 4, 2004 at 2:35 am
Thanks David,
I tried setting the max usable memory on the SQL SERVER to 1600 MB, but clussvc still seems to be having too many page faults , i've tried changing it to 1500 mb as you suggested, still the same, any ideas?
TIA
February 4, 2004 at 2:54 am
Hallo Jürgen,
not that I know too much of these things, but maybe these links will help you a little bit.
http://www.sql-server-performance.com/q&a114.asp
http://www.sql-server-performance.com/sg_sql_server_performance_article.asp
Good luck!
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply