Hi
When you start SQL Server, SQL Server memory usage may continue to steadily increase and not decrease, even when activity on the server is low. Additionally, the Task Manager and Performance Monitor may show that the physical memory available on the compu
ter is steadily decreasing until the available memory is between 4 to 10 MB.
This behavior alone does not indicate a memory leak. This behavior is normal and is an intended behavior of the SQL Server buffer pool.
Any solution
Thanks
Vinod
Solution to what ? What you just stated is normal from a SQL server memory
consumption .
"Vinod" <Vinod@.discussions.microsoft.com> wrote in message
news:43141E1A-70EB-46E1-BF26-298541492B3A@.microsoft.com...
> Hi
> When you start SQL Server, SQL Server memory usage may continue to
steadily increase and not decrease, even when activity on the server is low.
Additionally, the Task Manager and Performance Monitor may show that the
physical memory available on the computer is steadily decreasing until the
available memory is between 4 to 10 MB.
> This behavior alone does not indicate a memory leak. This behavior is
normal and is an intended behavior of the SQL Server buffer pool.
> Any solution
> Thanks
> Vinod
|||Hi Vinod,
This is a normal situation and will not be an issue if your server is
dedicated for SQL server alone. SQL Server
will release the memory if operating system requires more physical memory.
To restrict the memory usage you can set the memory to static. Set the "min
server memory and max server memory" to the same value.
See the details in "memory, max server memory option" in books online.
Thanks
Hari
MCDBA
"Vinod" <Vinod@.discussions.microsoft.com> wrote in message
news:43141E1A-70EB-46E1-BF26-298541492B3A@.microsoft.com...
> Hi
> When you start SQL Server, SQL Server memory usage may continue to
steadily increase and not decrease, even when activity on the server is low.
Additionally, the Task Manager and Performance Monitor may show that the
physical memory available on the computer is steadily decreasing until the
available memory is between 4 to 10 MB.
> This behavior alone does not indicate a memory leak. This behavior is
normal and is an intended behavior of the SQL Server buffer pool.
> Any solution
> Thanks
> Vinod
|||Hi Hari Prasad,
Thank you, I will try setting the min and max memory usage
Regards
Vinod
"Hari Prasad" wrote:
> Hi Vinod,
> This is a normal situation and will not be an issue if your server is
> dedicated for SQL server alone. SQL Server
> will release the memory if operating system requires more physical memory.
> To restrict the memory usage you can set the memory to static. Set the "min
> server memory and max server memory" to the same value.
> See the details in "memory, max server memory option" in books online.
> --
> Thanks
> Hari
> MCDBA
> "Vinod" <Vinod@.discussions.microsoft.com> wrote in message
> news:43141E1A-70EB-46E1-BF26-298541492B3A@.microsoft.com...
> steadily increase and not decrease, even when activity on the server is low.
> Additionally, the Task Manager and Performance Monitor may show that the
> physical memory available on the computer is steadily decreasing until the
> available memory is between 4 to 10 MB.
> normal and is an intended behavior of the SQL Server buffer pool.
>
>
|||If there aren't any performance issues currently on the Server then let the memory be managed dynamically instead of setting min and max values.
IN general leaving dynamic settings for memory on SQL is preferrable for better performance. If other application are sharing the server resources then you may test and set the values.
HTH
--
Satya SKJ
Visit http://www.sql-server-performance.com for tips and articles on Performance topic.
"Vinod" wrote:
[vbcol=seagreen]
> Hi Hari Prasad,
> Thank you, I will try setting the min and max memory usage
> Regards
> Vinod
> "Hari Prasad" wrote:
Showing posts with label steadily. Show all posts
Showing posts with label steadily. Show all posts
Monday, March 12, 2012
Memory Usage
Hi
When you start SQL Server, SQL Server memory usage may continue to steadily
increase and not decrease, even when activity on the server is low. Addition
ally, the Task Manager and Performance Monitor may show that the physical me
mory available on the compu
ter is steadily decreasing until the available memory is between 4 to 10 MB.
This behavior alone does not indicate a memory leak. This behavior is normal
and is an intended behavior of the SQL Server buffer pool.
Any solution
Thanks
VinodSolution to what ? What you just stated is normal from a SQL server memory
consumption .
"Vinod" <Vinod@.discussions.microsoft.com> wrote in message
news:43141E1A-70EB-46E1-BF26-298541492B3A@.microsoft.com...
> Hi
> When you start SQL Server, SQL Server memory usage may continue to
steadily increase and not decrease, even when activity on the server is low.
Additionally, the Task Manager and Performance Monitor may show that the
physical memory available on the computer is steadily decreasing until the
available memory is between 4 to 10 MB.
> This behavior alone does not indicate a memory leak. This behavior is
normal and is an intended behavior of the SQL Server buffer pool.
> Any solution
> Thanks
> Vinod|||Hi Vinod,
This is a normal situation and will not be an issue if your server is
dedicated for SQL server alone. SQL Server
will release the memory if operating system requires more physical memory.
To restrict the memory usage you can set the memory to static. Set the "min
server memory and max server memory" to the same value.
See the details in "memory, max server memory option" in books online.
Thanks
Hari
MCDBA
"Vinod" <Vinod@.discussions.microsoft.com> wrote in message
news:43141E1A-70EB-46E1-BF26-298541492B3A@.microsoft.com...
> Hi
> When you start SQL Server, SQL Server memory usage may continue to
steadily increase and not decrease, even when activity on the server is low.
Additionally, the Task Manager and Performance Monitor may show that the
physical memory available on the computer is steadily decreasing until the
available memory is between 4 to 10 MB.
> This behavior alone does not indicate a memory leak. This behavior is
normal and is an intended behavior of the SQL Server buffer pool.
> Any solution
> Thanks
> Vinod|||Hi Hari Prasad,
Thank you, I will try setting the min and max memory usage
Regards
Vinod
"Hari Prasad" wrote:
> Hi Vinod,
> This is a normal situation and will not be an issue if your server is
> dedicated for SQL server alone. SQL Server
> will release the memory if operating system requires more physical memory.
> To restrict the memory usage you can set the memory to static. Set the "mi
n
> server memory and max server memory" to the same value.
> See the details in "memory, max server memory option" in books online.
> --
> Thanks
> Hari
> MCDBA
> "Vinod" <Vinod@.discussions.microsoft.com> wrote in message
> news:43141E1A-70EB-46E1-BF26-298541492B3A@.microsoft.com...
> steadily increase and not decrease, even when activity on the server is lo
w.
> Additionally, the Task Manager and Performance Monitor may show that the
> physical memory available on the computer is steadily decreasing until the
> available memory is between 4 to 10 MB.
> normal and is an intended behavior of the SQL Server buffer pool.
>
>|||If there aren't any performance issues currently on the Server then let the
memory be managed dynamically instead of setting min and max values.
IN general leaving dynamic settings for memory on SQL is preferrable for bet
ter performance. If other application are sharing the server resources then
you may test and set the values.
HTH
--
--
Satya SKJ
Visit http://www.sql-server-performance.com for tips and articles on Perform
ance topic.
"Vinod" wrote:
[vbcol=seagreen]
> Hi Hari Prasad,
> Thank you, I will try setting the min and max memory usage
> Regards
> Vinod
> "Hari Prasad" wrote:
>
When you start SQL Server, SQL Server memory usage may continue to steadily
increase and not decrease, even when activity on the server is low. Addition
ally, the Task Manager and Performance Monitor may show that the physical me
mory available on the compu
ter is steadily decreasing until the available memory is between 4 to 10 MB.
This behavior alone does not indicate a memory leak. This behavior is normal
and is an intended behavior of the SQL Server buffer pool.
Any solution
Thanks
VinodSolution to what ? What you just stated is normal from a SQL server memory
consumption .
"Vinod" <Vinod@.discussions.microsoft.com> wrote in message
news:43141E1A-70EB-46E1-BF26-298541492B3A@.microsoft.com...
> Hi
> When you start SQL Server, SQL Server memory usage may continue to
steadily increase and not decrease, even when activity on the server is low.
Additionally, the Task Manager and Performance Monitor may show that the
physical memory available on the computer is steadily decreasing until the
available memory is between 4 to 10 MB.
> This behavior alone does not indicate a memory leak. This behavior is
normal and is an intended behavior of the SQL Server buffer pool.
> Any solution
> Thanks
> Vinod|||Hi Vinod,
This is a normal situation and will not be an issue if your server is
dedicated for SQL server alone. SQL Server
will release the memory if operating system requires more physical memory.
To restrict the memory usage you can set the memory to static. Set the "min
server memory and max server memory" to the same value.
See the details in "memory, max server memory option" in books online.
Thanks
Hari
MCDBA
"Vinod" <Vinod@.discussions.microsoft.com> wrote in message
news:43141E1A-70EB-46E1-BF26-298541492B3A@.microsoft.com...
> Hi
> When you start SQL Server, SQL Server memory usage may continue to
steadily increase and not decrease, even when activity on the server is low.
Additionally, the Task Manager and Performance Monitor may show that the
physical memory available on the computer is steadily decreasing until the
available memory is between 4 to 10 MB.
> This behavior alone does not indicate a memory leak. This behavior is
normal and is an intended behavior of the SQL Server buffer pool.
> Any solution
> Thanks
> Vinod|||Hi Hari Prasad,
Thank you, I will try setting the min and max memory usage
Regards
Vinod
"Hari Prasad" wrote:
> Hi Vinod,
> This is a normal situation and will not be an issue if your server is
> dedicated for SQL server alone. SQL Server
> will release the memory if operating system requires more physical memory.
> To restrict the memory usage you can set the memory to static. Set the "mi
n
> server memory and max server memory" to the same value.
> See the details in "memory, max server memory option" in books online.
> --
> Thanks
> Hari
> MCDBA
> "Vinod" <Vinod@.discussions.microsoft.com> wrote in message
> news:43141E1A-70EB-46E1-BF26-298541492B3A@.microsoft.com...
> steadily increase and not decrease, even when activity on the server is lo
w.
> Additionally, the Task Manager and Performance Monitor may show that the
> physical memory available on the computer is steadily decreasing until the
> available memory is between 4 to 10 MB.
> normal and is an intended behavior of the SQL Server buffer pool.
>
>|||If there aren't any performance issues currently on the Server then let the
memory be managed dynamically instead of setting min and max values.
IN general leaving dynamic settings for memory on SQL is preferrable for bet
ter performance. If other application are sharing the server resources then
you may test and set the values.
HTH
--
--
Satya SKJ
Visit http://www.sql-server-performance.com for tips and articles on Perform
ance topic.
"Vinod" wrote:
[vbcol=seagreen]
> Hi Hari Prasad,
> Thank you, I will try setting the min and max memory usage
> Regards
> Vinod
> "Hari Prasad" wrote:
>
Friday, March 9, 2012
Memory Usage
Hi
When you start SQL Server, SQL Server memory usage may continue to steadily increase and not decrease, even when activity on the server is low. Additionally, the Task Manager and Performance Monitor may show that the physical memory available on the computer is steadily decreasing until the available memory is between 4 to 10 MB.
This behavior alone does not indicate a memory leak. This behavior is normal and is an intended behavior of the SQL Server buffer pool.
Any solution
Thanks
VinodSolution to what ? What you just stated is normal from a SQL server memory
consumption .
"Vinod" <Vinod@.discussions.microsoft.com> wrote in message
news:43141E1A-70EB-46E1-BF26-298541492B3A@.microsoft.com...
> Hi
> When you start SQL Server, SQL Server memory usage may continue to
steadily increase and not decrease, even when activity on the server is low.
Additionally, the Task Manager and Performance Monitor may show that the
physical memory available on the computer is steadily decreasing until the
available memory is between 4 to 10 MB.
> This behavior alone does not indicate a memory leak. This behavior is
normal and is an intended behavior of the SQL Server buffer pool.
> Any solution
> Thanks
> Vinod|||Hi Vinod,
This is a normal situation and will not be an issue if your server is
dedicated for SQL server alone. SQL Server
will release the memory if operating system requires more physical memory.
To restrict the memory usage you can set the memory to static. Set the "min
server memory and max server memory" to the same value.
See the details in "memory, max server memory option" in books online.
--
Thanks
Hari
MCDBA
"Vinod" <Vinod@.discussions.microsoft.com> wrote in message
news:43141E1A-70EB-46E1-BF26-298541492B3A@.microsoft.com...
> Hi
> When you start SQL Server, SQL Server memory usage may continue to
steadily increase and not decrease, even when activity on the server is low.
Additionally, the Task Manager and Performance Monitor may show that the
physical memory available on the computer is steadily decreasing until the
available memory is between 4 to 10 MB.
> This behavior alone does not indicate a memory leak. This behavior is
normal and is an intended behavior of the SQL Server buffer pool.
> Any solution
> Thanks
> Vinod|||Hi Hari Prasad,
Thank you, I will try setting the min and max memory usage
Regards
Vinod
"Hari Prasad" wrote:
> Hi Vinod,
> This is a normal situation and will not be an issue if your server is
> dedicated for SQL server alone. SQL Server
> will release the memory if operating system requires more physical memory.
> To restrict the memory usage you can set the memory to static. Set the "min
> server memory and max server memory" to the same value.
> See the details in "memory, max server memory option" in books online.
> --
> Thanks
> Hari
> MCDBA
> "Vinod" <Vinod@.discussions.microsoft.com> wrote in message
> news:43141E1A-70EB-46E1-BF26-298541492B3A@.microsoft.com...
> > Hi
> >
> > When you start SQL Server, SQL Server memory usage may continue to
> steadily increase and not decrease, even when activity on the server is low.
> Additionally, the Task Manager and Performance Monitor may show that the
> physical memory available on the computer is steadily decreasing until the
> available memory is between 4 to 10 MB.
> >
> > This behavior alone does not indicate a memory leak. This behavior is
> normal and is an intended behavior of the SQL Server buffer pool.
> >
> > Any solution
> >
> > Thanks
> >
> > Vinod
>
>|||If there aren't any performance issues currently on the Server then let the memory be managed dynamically instead of setting min and max values.
IN general leaving dynamic settings for memory on SQL is preferrable for better performance. If other application are sharing the server resources then you may test and set the values.
HTH
--
--
Satya SKJ
Visit http://www.sql-server-performance.com for tips and articles on Performance topic.
"Vinod" wrote:
> Hi Hari Prasad,
> Thank you, I will try setting the min and max memory usage
> Regards
> Vinod
> "Hari Prasad" wrote:
> > Hi Vinod,
> >
> > This is a normal situation and will not be an issue if your server is
> > dedicated for SQL server alone. SQL Server
> > will release the memory if operating system requires more physical memory.
> >
> > To restrict the memory usage you can set the memory to static. Set the "min
> > server memory and max server memory" to the same value.
> >
> > See the details in "memory, max server memory option" in books online.
> >
> > --
> > Thanks
> > Hari
> > MCDBA
> >
> > "Vinod" <Vinod@.discussions.microsoft.com> wrote in message
> > news:43141E1A-70EB-46E1-BF26-298541492B3A@.microsoft.com...
> > > Hi
> > >
> > > When you start SQL Server, SQL Server memory usage may continue to
> > steadily increase and not decrease, even when activity on the server is low.
> > Additionally, the Task Manager and Performance Monitor may show that the
> > physical memory available on the computer is steadily decreasing until the
> > available memory is between 4 to 10 MB.
> > >
> > > This behavior alone does not indicate a memory leak. This behavior is
> > normal and is an intended behavior of the SQL Server buffer pool.
> > >
> > > Any solution
> > >
> > > Thanks
> > >
> > > Vinod
> >
> >
> >
When you start SQL Server, SQL Server memory usage may continue to steadily increase and not decrease, even when activity on the server is low. Additionally, the Task Manager and Performance Monitor may show that the physical memory available on the computer is steadily decreasing until the available memory is between 4 to 10 MB.
This behavior alone does not indicate a memory leak. This behavior is normal and is an intended behavior of the SQL Server buffer pool.
Any solution
Thanks
VinodSolution to what ? What you just stated is normal from a SQL server memory
consumption .
"Vinod" <Vinod@.discussions.microsoft.com> wrote in message
news:43141E1A-70EB-46E1-BF26-298541492B3A@.microsoft.com...
> Hi
> When you start SQL Server, SQL Server memory usage may continue to
steadily increase and not decrease, even when activity on the server is low.
Additionally, the Task Manager and Performance Monitor may show that the
physical memory available on the computer is steadily decreasing until the
available memory is between 4 to 10 MB.
> This behavior alone does not indicate a memory leak. This behavior is
normal and is an intended behavior of the SQL Server buffer pool.
> Any solution
> Thanks
> Vinod|||Hi Vinod,
This is a normal situation and will not be an issue if your server is
dedicated for SQL server alone. SQL Server
will release the memory if operating system requires more physical memory.
To restrict the memory usage you can set the memory to static. Set the "min
server memory and max server memory" to the same value.
See the details in "memory, max server memory option" in books online.
--
Thanks
Hari
MCDBA
"Vinod" <Vinod@.discussions.microsoft.com> wrote in message
news:43141E1A-70EB-46E1-BF26-298541492B3A@.microsoft.com...
> Hi
> When you start SQL Server, SQL Server memory usage may continue to
steadily increase and not decrease, even when activity on the server is low.
Additionally, the Task Manager and Performance Monitor may show that the
physical memory available on the computer is steadily decreasing until the
available memory is between 4 to 10 MB.
> This behavior alone does not indicate a memory leak. This behavior is
normal and is an intended behavior of the SQL Server buffer pool.
> Any solution
> Thanks
> Vinod|||Hi Hari Prasad,
Thank you, I will try setting the min and max memory usage
Regards
Vinod
"Hari Prasad" wrote:
> Hi Vinod,
> This is a normal situation and will not be an issue if your server is
> dedicated for SQL server alone. SQL Server
> will release the memory if operating system requires more physical memory.
> To restrict the memory usage you can set the memory to static. Set the "min
> server memory and max server memory" to the same value.
> See the details in "memory, max server memory option" in books online.
> --
> Thanks
> Hari
> MCDBA
> "Vinod" <Vinod@.discussions.microsoft.com> wrote in message
> news:43141E1A-70EB-46E1-BF26-298541492B3A@.microsoft.com...
> > Hi
> >
> > When you start SQL Server, SQL Server memory usage may continue to
> steadily increase and not decrease, even when activity on the server is low.
> Additionally, the Task Manager and Performance Monitor may show that the
> physical memory available on the computer is steadily decreasing until the
> available memory is between 4 to 10 MB.
> >
> > This behavior alone does not indicate a memory leak. This behavior is
> normal and is an intended behavior of the SQL Server buffer pool.
> >
> > Any solution
> >
> > Thanks
> >
> > Vinod
>
>|||If there aren't any performance issues currently on the Server then let the memory be managed dynamically instead of setting min and max values.
IN general leaving dynamic settings for memory on SQL is preferrable for better performance. If other application are sharing the server resources then you may test and set the values.
HTH
--
--
Satya SKJ
Visit http://www.sql-server-performance.com for tips and articles on Performance topic.
"Vinod" wrote:
> Hi Hari Prasad,
> Thank you, I will try setting the min and max memory usage
> Regards
> Vinod
> "Hari Prasad" wrote:
> > Hi Vinod,
> >
> > This is a normal situation and will not be an issue if your server is
> > dedicated for SQL server alone. SQL Server
> > will release the memory if operating system requires more physical memory.
> >
> > To restrict the memory usage you can set the memory to static. Set the "min
> > server memory and max server memory" to the same value.
> >
> > See the details in "memory, max server memory option" in books online.
> >
> > --
> > Thanks
> > Hari
> > MCDBA
> >
> > "Vinod" <Vinod@.discussions.microsoft.com> wrote in message
> > news:43141E1A-70EB-46E1-BF26-298541492B3A@.microsoft.com...
> > > Hi
> > >
> > > When you start SQL Server, SQL Server memory usage may continue to
> > steadily increase and not decrease, even when activity on the server is low.
> > Additionally, the Task Manager and Performance Monitor may show that the
> > physical memory available on the computer is steadily decreasing until the
> > available memory is between 4 to 10 MB.
> > >
> > > This behavior alone does not indicate a memory leak. This behavior is
> > normal and is an intended behavior of the SQL Server buffer pool.
> > >
> > > Any solution
> > >
> > > Thanks
> > >
> > > Vinod
> >
> >
> >
Subscribe to:
Posts (Atom)