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

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 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 leak or performance issue?

Dear all
My some users are complaining that when they restart their sql server
it works good for some time and then as time pass performance degrades.
Again they resrat and it works fine and as time goes it becomes slow.
Why when I restart it works fine and as time goes it becomes slow?
Is there any memory leak or any other problem for this?
Regards
AmishHi,
What is databaser server configuration hw and sw ?
- Windows version ?
- SQL Server version and SP ?
- How many memory do you want ?
- How many processors do you want ?
** * Esta msg foi útil pra você ? Então marque-a como tal. ***
Regards,
Rodrigo Fernandes
"amish" wrote:
> Dear all
> My some users are complaining that when they restart their sql server
> it works good for some time and then as time pass performance degrades.
> Again they resrat and it works fine and as time goes it becomes slow.
> Why when I restart it works fine and as time goes it becomes slow?
> Is there any memory leak or any other problem for this?
>
> Regards
> Amish
>

Memory leak or performance issue?

Dear all
My some users are complaining that when they restart their sql server
it works good for some time and then as time pass performance degrades.
Again they resrat and it works fine and as time goes it becomes slow.
Why when I restart it works fine and as time goes it becomes slow?
Is there any memory leak or any other problem for this?
Regards
AmishHi,
What is databaser server configuration hw and sw ?
- Windows version ?
- SQL Server version and SP ?
- How many memory do you want ?
- How many processors do you want ?
** * Esta msg foi útil pra você ? Ent?o marque-a como tal. ***
Regards,
Rodrigo Fernandes
"amish" wrote:

> Dear all
> My some users are complaining that when they restart their sql server
> it works good for some time and then as time pass performance degrades.
> Again they resrat and it works fine and as time goes it becomes slow.
> Why when I restart it works fine and as time goes it becomes slow?
> Is there any memory leak or any other problem for this?
>
> Regards
> Amish
>