Memory usage

Why the memory usage in task manager shows significant difference before and
after the restart of SQL Server service ? Is that due to the memory leak ?
I am running SQL Server 2000 sp3a
Thanks very much,
natasa
Natasa,
If SQL Server's memory is set to be dynamic (default), it will grow to the
min boundary then up-to the max boundary (if needed) then fluctuate in
between.
HTH
Jerry
"natasa" <natasa@.discussions.microsoft.com> wrote in message
news:C0197641-02D7-460F-8346-E3609CD4E15C@.microsoft.com...
> Why the memory usage in task manager shows significant difference before
> and
> after the restart of SQL Server service ? Is that due to the memory leak ?
> I am running SQL Server 2000 sp3a
> Thanks very much,
> natasa
|||also if you have /PAE enabled (> 4GB RAM) , Task Manager will say a silly
amount for SQLServr.exe - around 100mb. In this scenario Perfmon/SQL Server
Memory Manager/Total Server Memory is the correct thing to look at
cheers,
Andy
"natasa" <natasa@.discussions.microsoft.com> wrote in message
news:C0197641-02D7-460F-8346-E3609CD4E15C@.microsoft.com...
> Why the memory usage in task manager shows significant difference before
> and
> after the restart of SQL Server service ? Is that due to the memory leak ?
> I am running SQL Server 2000 sp3a
> Thanks very much,
> natasa
|||to regulate SQL memory usage
use WSRM windows system resource manager
for win2k3
thanks,
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787
"natasa" wrote:

> Why the memory usage in task manager shows significant difference before and
> after the restart of SQL Server service ? Is that due to the memory leak ?
> I am running SQL Server 2000 sp3a
> Thanks very much,
> natasa

Memory usage

Why the memory usage in task manager shows significant difference before and
after the restart of SQL Server service ? Is that due to the memory leak ?
I am running SQL Server 2000 sp3a
Thanks very much,
natasaNatasa,
If SQL Server's memory is set to be dynamic (default), it will grow to the
min boundary then up-to the max boundary (if needed) then fluctuate in
between.
HTH
Jerry
"natasa" <natasa@.discussions.microsoft.com> wrote in message
news:C0197641-02D7-460F-8346-E3609CD4E15C@.microsoft.com...
> Why the memory usage in task manager shows significant difference before
> and
> after the restart of SQL Server service ? Is that due to the memory leak ?
> I am running SQL Server 2000 sp3a
> Thanks very much,
> natasa|||also if you have /PAE enabled (> 4GB RAM) , Task Manager will say a silly
amount for SQLServr.exe - around 100mb. In this scenario Perfmon/SQL Server
Memory Manager/Total Server Memory is the correct thing to look at
cheers,
Andy
"natasa" <natasa@.discussions.microsoft.com> wrote in message
news:C0197641-02D7-460F-8346-E3609CD4E15C@.microsoft.com...
> Why the memory usage in task manager shows significant difference before
> and
> after the restart of SQL Server service ? Is that due to the memory leak ?
> I am running SQL Server 2000 sp3a
> Thanks very much,
> natasa|||to regulate SQL memory usage
use WSRM windows system resource manager
for win2k3
thanks,
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787
"natasa" wrote:

> Why the memory usage in task manager shows significant difference before a
nd
> after the restart of SQL Server service ? Is that due to the memory leak ?
> I am running SQL Server 2000 sp3a
> Thanks very much,
> natasa