When using Sql Server 2K5,I find that the process "SqlServer.exe" sometimes occupy high memory usage and suddenly drop to a low value by monitoring the "Windows Task Manager".
And the "Buffer Pool" is the largest memory consumer in my sql server.
The "DBCC MemoryStatus" command shows me that:
Memory Manager KB
VM Reserved 16977864
VM Committed 13951624
AWE Allocated 0
Reserved Memory 1024
Reserved Memory In Use 0
Buffer Distribution Buffers
Stolen 17966
Free 364
Cached 116132
Database (clean) 1348449
Database (dirty) 206865
I/O 0
Latched 2
Buffer Counts Buffers
Committed 1689778
Target 1767335
Hashed 1555316
Stolen Potential 1733678
External Reservation 0
Min Free 208
Visible 1767335
Available Paging File 663931
My question is:
1. If Sql Server.exe will release the memory for other process occpuy the OS resouce? So that means the PageOut issues occurs?
2. What will happend if the buffer pool size is continously increasing?
