I have a SQL server 2008 R2 server that hosts our production database. We are getting ready to take on the biggest load we have ever seen in our history. I am trying to gather some information to decide how much RAM \ CPU \ DISK \ ect that I need to add to accomplish this task. I am also trying to be a little proactive on some configuration things to do so we can get through these peak times (increase the DBCC buffer cache, etc).
It's been a while since doing this....What should I be gathering in perfmon \ SQL profiler to get a good guess as to what my big production load will be like?
Our intent is to put a stress test on the front and back end, then gather metrics during this test...I just need a clue as to what some good metrics are to gather.