February 19, 2010 at 2:01 am
in my environment one of the server's memory is hitting 95% every time..but at that particular time jobs are not running..can anyone suggest wat can be the reasons for this..
February 19, 2010 at 2:36 am
When did this problem start happening?
I was not clear if this is happening 24/7 or not?
Have you gone into task Manager checked show all process and sorted by Memory Usage in descending order?
How much memory is SQL Server consuming?
http://support.microsoft.com/kb/271624
What OS are you using and what SP?
Is this a clustered environment?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 19, 2010 at 2:40 am
Based on your answers to my questions I may have some additional information that will hopefully be helpful to you...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 19, 2010 at 2:42 am
Have u changed any sp_configure settings?
sply min memory,max memory
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
February 19, 2010 at 4:58 am
shanila_minnu (2/19/2010)
in my environment one of the server's memory is hitting 95% every time..but at that particular time jobs are not running..can anyone suggest wat can be the reasons for this..
First what's your environment ?
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 19, 2010 at 5:15 am
i will check & let you know
February 23, 2010 at 1:22 am
Welsh Corgi (2/19/2010)
When did this problem start happening?I was not clear if this is happening 24/7 or not?
Have you gone into task Manager checked show all process and sorted by Memory Usage in descending order?
How much memory is SQL Server consuming?
http://support.microsoft.com/kb/271624
What OS are you using and what SP?
Is this a clustered environment?
February 23, 2010 at 1:23 am
Welsh Corgi (2/19/2010)
When did this problem start happening?I was not clear if this is happening 24/7 or not?
Have you gone into task Manager checked show all process and sorted by Memory Usage in descending order?
How much memory is SQL Server consuming?
http://support.microsoft.com/kb/271624
What OS are you using and what SP?
Is this a clustered environment?
1)we noticed two months back...
2)memory is hitting most of the time..not 24/7
3)23564 K is memory usage of sql server
4)OS is windows server 2003 SP1
5)it is clustered environment
February 23, 2010 at 11:01 am
Is this x64 system?
If so, have you set max memory?
How much memory is available to the system?
If you have 24GB of memory available - you should be setting the max memory for SQL Server to no more than 20GB, leaving the OS 4GB of memory to manage the system. If this is not a dedicated SQL Server machine and you have other applications running, you may need to limit the max memory even more.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 23, 2010 at 10:32 pm
Also,
What's your sql server version?
What's your cluster type?
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply