I need to provide proof to senior mgrs of an overkill memory request
Posted on 2009-04-05
Okay so here is the problem. I have a senior developer in my office who is requesting the maximum amount of RAM (32GB) for a SQL server in our shop. I've asked for documentation of memory related errors or performance charts indicating a memory bottle neck but have not recieved anything. This is the first place I've been where they are considering a purchase with no documentation to say that it is necessary.
Server Specs: PowerEdge 2950 III, Single Xeon Quad Core 2.0GHz, 16GB RAM, 15k RPM hard disks (databases, Logs, & paging all on seperate redundant Raid 10 disk arrays), server 2003 Standard x64, sql server 2005 standard.
What does this server do? Well the most information I can give you is that it is the backend to a client portal that hosts less 1000 users. The client portal is for the clients to upload a file no larger than 1GB or 1 million records, but the average file is less than half of this amount.
My limitation on this is that I know very little about SQL so I do not attempt to challenge him on it. However I do know the hardware pretty well and he doesn't yet he he is constantly challenging me on server specifications. The problem is that our supervisors are clueless when it comes to this. So any thoughts?
I do have performance monitor files, with several SQL counters available for review if requested. Thanks in advance!