December 15, 2003 at 7:14 am
Hello!!!
I had one SQL Server 2k with Windows Server 2k and in the last two days a go they started usage a larger quantity of memory.
I thought this happend because a slamer virus but after I did the update to SP 3a but teh SQL continuous using a must memory.
What I can do to done the memory usage is the satisfable???
December 15, 2003 at 10:30 am
SQL will take as much memory as it needs and balance itself with other applications, though this can be slow. The OS should manage this, but it might not work for you, or not be quick enough. If memory is growing in SQL Server, either the load has changed (and the SQL server wants more) or there is a leak, possibly due to some XP you have).
How much memory is on the server and how much is SQL using?
You can also set the memory SQL uses to a max (EM, right click sever, properties, memory tab).
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 16, 2003 at 3:33 am
Hi Steve,
I had this but they continue growup the memory higher than that I configure.
Because this I installer the SP3.
But before configure the memory to fixed in the 200MB and reserve this physical memory.
The continue using memory higher 400MB.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply