Memory Question

SQL Server 2000
I cannot seem to find a straight answer on Microsoft's website, so i thought
i would ask here.
I notice that throughout the day, the memory usage on the SQL Server process
goes up and up and up, starting at 24meg at the beginning of the day getting
up to 800meg.
Does this mean that i have a memory leak somewhere or is this normal? The
server seems to get slower and slower as the day progresses.
TIA
Tim MorrisonIt just means SQL Server is consuming more memory. To test for a memory leak
observe available bytes, see if it drops over time and then stop SQL Server
and see if available bytes returns to the level it was at before.
When you have performance degradation it could be because the data or
procedure cache is getting full. You need to evaluate your procs and any ad
hoq sql you may be running. Ideally all ad hoq sql will be run as stored
procedures. You also need to evaluate which procs are the worst performing.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tim Morrison" <sales@.NOSPAM_kjmsoftware.com> wrote in message
news:O8F3XcoAHHA.5060@.TK2MSFTNGP02.phx.gbl...
> SQL Server 2000
> I cannot seem to find a straight answer on Microsoft's website, so i
> thought i would ask here.
> I notice that throughout the day, the memory usage on the SQL Server
> process goes up and up and up, starting at 24meg at the beginning of the
> day getting up to 800meg.
> Does this mean that i have a memory leak somewhere or is this normal? The
> server seems to get slower and slower as the day progresses.
> TIA
> Tim Morrison
>
>|||This is normal. check your sql server memory configuration
open EM->Right click on the server and select the property->
open the memory tab and check
Dynamically configure sql server memory setting
if this the configuration on your server then will try to use the available
memory when needed
vinu
"Tim Morrison" <sales@.NOSPAM_kjmsoftware.com> wrote in message
news:O8F3XcoAHHA.5060@.TK2MSFTNGP02.phx.gbl...
> SQL Server 2000
> I cannot seem to find a straight answer on Microsoft's website, so i
> thought i would ask here.
> I notice that throughout the day, the memory usage on the SQL Server
> process goes up and up and up, starting at 24meg at the beginning of the
> day getting up to 800meg.
> Does this mean that i have a memory leak somewhere or is this normal? The
> server seems to get slower and slower as the day progresses.
> TIA
> Tim Morrison
>
>