SQL Server not using enough memory
Posted on 2006-05-01
SQL Server 2000 Ent on W2K Advanced SP4.
Server running with /AWE and 8G of RAM.
SQL Server uses ~100M (yes M) accoridng to task manager and we are seeing slowness and timeouts.
Task mgr shows total memory usage at 6.5G leaving 1.5G free. The sum of the memory consumption for all process in task mgr is less than 2G so:
1.What's using most of the 6.5G supposedly allocated or how do I investigate that?
2.Is SQL server really using only 100M and how can I check that? Therea re about 10 dbs and a few dozen nominal users with up to 2000 actual users. We shoudlbe getting far better perf from that box than we are seeing, based on comparisons with other boxes.