|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!"