memoryleak?

Hello,
I've monitoring my sql server 2000 for awhile now and i see in the
taskmanager that the memoryusage was very high.
If nobody is doing something in the database the memory is at approx. 23 mb,
but when there are connections with sql server the memory increases to above
100mb!.
Is this normal behavior, because i can't tell. My server has w2k advanced
server as the os and has 2 processor and a gigabyte of memory.
ThnxThis should explain it:
INF: SQL Server Memory Usage
http://support.microsoft.com/default.aspx?scid=kb;en-us;321363
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Ezekiël" <ezekiël@.lycos.com> wrote in message
news:%23JNn1m4fEHA.3928@.TK2MSFTNGP11.phx.gbl...
Hello,
I've monitoring my sql server 2000 for awhile now and i see in the
taskmanager that the memoryusage was very high.
If nobody is doing something in the database the memory is at approx. 23 mb,
but when there are connections with sql server the memory increases to above
100mb!.
Is this normal behavior, because i can't tell. My server has w2k advanced
server as the os and has 2 processor and a gigabyte of memory.
Thnxsql

memoryleak?

Hello,
I've monitoring my sql server 2000 for awhile now and i see in the
taskmanager that the memoryusage was very high.
If nobody is doing something in the database the memory is at approx. 23 mb,
but when there are connections with sql server the memory increases to above
100mb!.
Is this normal behavior, because i can't tell. My server has w2k advanced
server as the os and has 2 processor and a gigabyte of memory.
Thnx
This should explain it:
INF: SQL Server Memory Usage
http://support.microsoft.com/default...b;en-us;321363
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Ezekil" <ezekil@.lycos.com> wrote in message
news:%23JNn1m4fEHA.3928@.TK2MSFTNGP11.phx.gbl...
Hello,
I've monitoring my sql server 2000 for awhile now and i see in the
taskmanager that the memoryusage was very high.
If nobody is doing something in the database the memory is at approx. 23 mb,
but when there are connections with sql server the memory increases to above
100mb!.
Is this normal behavior, because i can't tell. My server has w2k advanced
server as the os and has 2 processor and a gigabyte of memory.
Thnx

memoryleak?

Hello,
I've monitoring my sql server 2000 for awhile now and i see in the
taskmanager that the memoryusage was very high.
If nobody is doing something in the database the memory is at approx. 23 mb,
but when there are connections with sql server the memory increases to above
100mb!.
Is this normal behavior, because i can't tell. My server has w2k advanced
server as the os and has 2 processor and a gigabyte of memory.
ThnxThis should explain it:
INF: SQL Server Memory Usage
http://support.microsoft.com/defaul...kb;en-us;321363
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Ezekil" <ezekil@.lycos.com> wrote in message
news:%23JNn1m4fEHA.3928@.TK2MSFTNGP11.phx.gbl...
Hello,
I've monitoring my sql server 2000 for awhile now and i see in the
taskmanager that the memoryusage was very high.
If nobody is doing something in the database the memory is at approx. 23 mb,
but when there are connections with sql server the memory increases to above
100mb!.
Is this normal behavior, because i can't tell. My server has w2k advanced
server as the os and has 2 processor and a gigabyte of memory.
Thnx

Memory problem related to DBCC CHECKDB

I have been monitoring my SQL server and noticing abrupt drops in Available
Memory -- happening about once a week.
I could not figure out what was causing this until I discovered that the low
memory condition corresponded to the exact time that I run a weekly DBCC CH
ECKDB command on a database.
Scenario:
1. Available Memory starts at about 1000MB (this is normal)
2. Run DBCC CHECKDB on a particular database (only occurs on this one).
3. Available Memory suddently drops to less than 200MB free!
4. The Memory is never freed up until I re-start SQL Server.
Has anyone ever seen this problem before?
Thanks,
DanIt is by Design.
SQL Server will not relinquish memory once allocated, unless there is a requ
est from the OS
--
HTH
Satish Balusa
Corillian Corp.
"Dan Carollo" <dan.carollo@.verizon.net> wrote in message news:uw$X%23mS5DHA.
2764@.TK2MSFTNGP09.phx.gbl...
I have been monitoring my SQL server and noticing abrupt drops in Available
Memory -- happening about once a week.
I could not figure out what was causing this until I discovered that the low
memory condition corresponded to the exact time that I run a weekly DBCC CH
ECKDB command on a database.
Scenario:
1. Available Memory starts at about 1000MB (this is normal)
2. Run DBCC CHECKDB on a particular database (only occurs on this one).
3. Available Memory suddently drops to less than 200MB free!
4. The Memory is never freed up until I re-start SQL Server.
Has anyone ever seen this problem before?
Thanks,
Dan|||Dan,
What is wrong with this?
If you still have available memory ... your performance is not hurting.
Most of this memory is most likely in buffer cache.
-Lars
"Dan Carollo" <dan.carollo@.verizon.net> wrote in message news:uw$X%23mS5DHA.
2764@.TK2MSFTNGP09.phx.gbl...
I have been monitoring my SQL server and noticing abrupt drops in Available
Memory -- happening about once a week.
I could not figure out what was causing this until I discovered that the low
memory condition corresponded to the exact time that I run a weekly DBCC CH
ECKDB command on a database.
Scenario:
1. Available Memory starts at about 1000MB (this is normal)
2. Run DBCC CHECKDB on a particular database (only occurs on this one).
3. Available Memory suddently drops to less than 200MB free!
4. The Memory is never freed up until I re-start SQL Server.
Has anyone ever seen this problem before?
Thanks,
Dan|||Further to what other replies have said, it is buffer pool memory. DBCC CHEC
KDB reads every allocated page in the database using parallel threads and si
gnificant readahead and so the buffer pool grows to accomodate this.
As long as you're not short of memory, there's no big deal.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dan Carollo" <dan.carollo@.verizon.net> wrote in message news:uw$X#mS5DHA.27
64@.TK2MSFTNGP09.phx.gbl...
I have been monitoring my SQL server and noticing abrupt drops in Available
Memory -- happening about once a week.
I could not figure out what was causing this until I discovered that the low
memory condition corresponded to the exact time that I run a weekly DBCC CH
ECKDB command on a database.
Scenario:
1. Available Memory starts at about 1000MB (this is normal)
2. Run DBCC CHECKDB on a particular database (only occurs on this one).
3. Available Memory suddently drops to less than 200MB free!
4. The Memory is never freed up until I re-start SQL Server.
Has anyone ever seen this problem before?
Thanks,
Dan

Memory pressure while running Perfmon?

I ran a perfmon trace with Memory counters (part of periodic monitoring
effort). I noticed that the SQL Server:Buffer Manager, Free pages
counter had dipped to 317, 203, etc (nromal values> 10000). The first
time this happened today coincided with the time I started the Perfmon
trace (run from another server and inserted into a DB on this second
server).
Does Perfmon cause Memory pressure on the server whose counters it is
capturing - even if it isn't running on that server?
Thanks.<smithabreddy@.gmail.com> wrote in message
news:1148050087.274820.88350@.j55g2000cwa.googlegroups.com...
>I ran a perfmon trace with Memory counters (part of periodic monitoring
> effort). I noticed that the SQL Server:Buffer Manager, Free pages
> counter had dipped to 317, 203, etc (nromal values> 10000). The first
> time this happened today coincided with the time I started the Perfmon
> trace (run from another server and inserted into a DB on this second
> server).
> Does Perfmon cause Memory pressure on the server whose counters it is
> capturing - even if it isn't running on that server?
>
No. It does not.
David