SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL Server Memory/Speed issues
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

txgeekgirl
Starting Member

18 Posts

Posted - 10/04/2012 :  15:30:53  Show Profile  Reply with Quote
We are running a database that is 80GB on a new server (Win 2008 R2 DataCenter SP1) using SQL SERVER 2008 R2 SP2. We are throwing 8CPU, 64GB RAM, and have page filing set to server specs. Turned off Trusted Installer, have the buffer cache set to 14GB, and run about 200 users. We are experiencing massive RAM issues. Processes will show that SQL is using between 7-15 GB between 8am - 11PM but we are at a constant 50-57GB used. We are running a SQL Job to clean the buffer every 15 min. That does seem to help bring RAM down a bit.

What else can we do?

chadmat
The Chadinator

USA
1974 Posts

Posted - 10/04/2012 :  17:00:06  Show Profile  Visit chadmat's Homepage  Reply with Quote
Why have you limited SQL to only 14GB of 64? I would set it up to about 56GB.

-Chad
Go to Top of Page

chadmat
The Chadinator

USA
1974 Posts

Posted - 10/04/2012 :  17:00:51  Show Profile  Visit chadmat's Homepage  Reply with Quote
Assuming that this server is dedicated to SQL Server.

-Chad
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35954 Posts

Posted - 10/04/2012 :  17:29:02  Show Profile  Visit tkizer's Homepage  Reply with Quote
quote:
Originally posted by txgeekgirl

We are running a SQL Job to clean the buffer every 15 min.



Why are you doing this? What problem are you trying to solve? Explain "massive RAM issues" in more detail, please.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

chadmat
The Chadinator

USA
1974 Posts

Posted - 10/04/2012 :  17:38:52  Show Profile  Visit chadmat's Homepage  Reply with Quote
quote:
Originally posted by tkizer

quote:
Originally posted by txgeekgirl

We are running a SQL Job to clean the buffer every 15 min.



Why are you doing this? What problem are you trying to solve? Explain "massive RAM issues" in more detail, please.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog



+1

No good can come from this.

-Chad
Go to Top of Page

txgeekgirl
Starting Member

18 Posts

Posted - 10/05/2012 :  00:06:06  Show Profile  Reply with Quote
The SQL Server consistently needs between 7-14GB to run. Cleaning the cache lowered the RAM by 2-10GB per flush.

What we found out was that having it on an overused Virtual Host was causing the issues.

After moving it to a lesser used virtual host, the CPU usage went way down, the RAM went from 56-60 to 13-15 - we moved the SQL Server memory Max to 24GB, leaving the rest for user use.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35954 Posts

Posted - 10/05/2012 :  00:44:16  Show Profile  Visit tkizer's Homepage  Reply with Quote
quote:
Originally posted by txgeekgirl

The SQL Server consistently needs between 7-14GB to run. Cleaning the cache lowered the RAM by 2-10GB per flush.

What we found out was that having it on an overused Virtual Host was causing the issues.

After moving it to a lesser used virtual host, the CPU usage went way down, the RAM went from 56-60 to 13-15 - we moved the SQL Server memory Max to 24GB, leaving the rest for user use.



SQL Server needs 7-14GB to run? What? That doesn't make any sense. Of course clearing the cache cleared out some memory, but that's not an efficient thing to do. The stuff was in memory for a reason. You are only causing performance problems by clearing out the cache regularly.

Why are you setting the SQL Server memory so low? SQL Server is a memory hog. It's designed that way. Give it maybe 64-72GB if it is dedicated to SQL Server.

I still don't understand what problem you are having, but you are definitely causing performance problems by doing these things.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35954 Posts

Posted - 10/05/2012 :  00:46:04  Show Profile  Visit tkizer's Homepage  Reply with Quote
I am so confused by this thread. What am I missing? I have a server with 96GB of memory. We have SQL Server configured to use 84GB of it, and it's quite happy that way. It uses all of that 84GB, and we have no need to clear out the cache as that defeats the purpose of memory.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000