SQL Server Performance  Quantifying memory bottlenecks
Discussion in 'Performance Tuning for DBAs' started by Chappy,
Nov 7, 2002.    1. Chappy New Member      I have 1GB RAM in my
server, to service ~70 users. This server runs ~10 databases, of
12 gig, 4 gig, 2 gig and the rest below a gig. Im pretty sure
the server would benefit massively from more memory, but im
struggling to quantify this. Ive check perfmon stats, and query
traces, but im struggling to differentiate normal disk IO from
IO caused by paging. Naturally SQL server consumes most the RAM,
but im sure it would do this anyway because it has no reason to
give it up (dedicated server).      What would be the best
approach to demonstrating that the server is short of RAM?    2.
HarryArchibald New Member      I found myself in a similar
situation and I used the perfmon executable to log Memory
Pages/sec for a day. If this is consistently over 20, then the
server is paging and requries more RAM.    3. satya Moderator
BTW what are settings for mi