Memory Leaking

#41

Basically I have two Servers, one is Sharepoint and other one is SQL Server
which is dedicated for Sharepoint.

SQL Server eats 7 GB of memory and as per your suggession, I will max it 6
GB and leave 2 GB for OS.

I am also thinking for any patch / hot fixes that might fix this problem?

Thanks

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Quote:

Well that depends on what you are trying to do and what you have to work
with. If you have 8GB I would leave ~1 to 2GB for the OS etc. So try
setting the MAX Memory setting of SQL Server to ~6GB. If you find you
always have plenty available you can bump it up from there.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Rogers" <Rogers (AT) discussions (DOT) microsoft.com> wrote in message
news:A30A344D-39BB-41AD-8813-28F4FC702503 (AT) microsoft (DOT) com...
Thanks for your reply, I didn't configure it, what is the formula to
configure it?

Thanks

"Andrew J. Kelly" wrote:

How is it configured? SQL Server by design will use almost ALL memory
unless you configure it not to.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Rogers" <Rogers (AT) discussions (DOT) microsoft.com> wrote in message
news:9DC34966-F3D4-49E6-A209-D6D99855A483 (AT) microsoft (DOT) com...
I have production SQL Server Standard Edition and found that SQL Server
is
eating 95% of memory.

We have 8 GB memory installed on the Server and dedicated for
Microsoft
Share point Server.

Please advice.

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Memory Leaking

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Re: Memory Leaking - 09-21-2008 , 12:40 PM