August 20, 2004 at 6:07 am
Hi
Our sqlserver seems to allocate a lot of memeory. When we start it it is all ok, as time go by, aprox an hour or two, memory increases rapidly. at the moment task manager reports that sqlservr.exe has a mem usage:604 212 K, and still counting. 10 minutes ago it was no more then 100 000 K. The server more or less stops when mem usage goes skyhigh. No jobs running.
My questions:
1: does there exist any tool to monitor what sqlserver.exe puts into mem?
2: does there exist any tool to control sqlserver usage of mem? Including the possibility to flush sqlservr.exe from mem?
Aas this is abit critical I hope that someone can give me some tips regarding this.
Thanks in advance for all your time.
Best regards
Dan
August 20, 2004 at 7:36 am
That is the nature of SQL Server, It allocates as much as it needs.
You can limit max memory SQL Server can use by configuring the min and max memory from either EM or sp_configure command.
Use performance monitor to watch how SQL Server consumes memory and other system resources.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply