SQL RAM Configuration question

Microsoft Windows server 2008 r2 enterpr...
November 5, 2010 at 13:16:48
Specs: Windows Server 2008 R2
I have not seen a network set up like this in a while so somehow I've lost the ability to explain the following to the manager of a network in a company I just joined. Please help explain the following so I can relay

We are writing tons of data to SQL 24/7. I won't explain why, but suffice it to say our databases are in the 500 to 1000 GB size, legitimately. We have many setups like this. For some reason they have decided to give 32GB RAM to SQL and leave 32 GB RAM to the OS. Basically the database records tons of transactional entries for data that is coming in and then we store that data on the bulk iSCSI SAN storage. They think that 32GB RAM for the OS helps it transmit data to the storage. Ironically their page file is maxed out on every system which means there's not enough RAM right? How do I determine if the OS really needs that much RAM and how do I determine how much RAM to provide SQL. I know the server will take as much as you configure it to use (SQL 2008 R2) so I can't add RAM and then see "hey SQL is only using 75%. Looks like we provided enough!"

See More: SQL RAM Configuration question

Report •

November 5, 2010 at 13:53:50
"Ironically their page file is maxed out on every system which means there's not enough RAM right?"

Not necessarily. Can you provide some of the stats from this maxed out pagefile?

Have you run performance monitor on this server?

Report •

November 5, 2010 at 14:13:53
We have run perfmon. What counters would you like to see?

Report •

November 5, 2010 at 14:55:23
Like to see the pagefile stats first. Thanks

Simple post of task manager performanc tab would be helpful

Report •
Related Solutions

Ask Question