Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
samihcl
Starting Member
6 Posts |
Posted - 2013-05-21 : 07:04:43
|
Dear All,Last night onward my memory utilization is going beyond 90%.We have sql server 2008 r2 with two node cluster.we have not done any changes/modificationPls suggest how to rectify this issue..its urgent.Thanks in advanceRegards, |
|
Robowski
Posting Yak Master
101 Posts |
Posted - 2013-05-21 : 07:43:35
|
I usually find that the sqlserv.exe will eventually consume all the memory if not rebooted perhaps once a week.quote: Originally posted by samihcl Dear All,Last night onward my memory utilization is going beyond 90%.We have sql server 2008 r2 with two node cluster.we have not done any changes/modificationPls suggest how to rectify this issue..its urgent.Thanks in advanceRegards,
|
|
|
samihcl
Starting Member
6 Posts |
Posted - 2013-05-21 : 07:48:19
|
thank for reply..rebooting is the solution??After rebooting..with in 4 to 5 hours memory will again reach to 90%Pls tell the workaround or permanent solution Regards |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2013-05-21 : 08:02:03
|
SQL Server is designed to use all the available RAM on a system. This is normal, and desired, as it improves performance by keeping data in RAM rather than having to read it from disk.The only way to prevent this is to set a max server memory limit. Details are here: http://msdn.microsoft.com/en-us/library/ms178067.aspxThere's no reason to ever reboot a SQL Server just to limit memory. Setting a max memory limit will take effect immediately, although memory may take a few minutes to free up. |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2013-05-21 : 12:23:06
|
don't reboot your database servers.... they may not start up again....Transact CharlieMsg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. http://nosqlsolution.blogspot.co.uk/ |
|
|
|
|
|