Get history report of the CPU/Memory usage on windows

How to get history report of the CPU/Memory usage on windows 2008 R2 (64-bit)

Below are from the above link:

Perfmon in server 2008 really is your best option.

We will use system memory as an example but you can add the processor counters just as easily.

Start>run>perfmon

In the left, expand "Monitoring Tools". Now right click "Performance Monitor" and choose, "New">"Data Collector Set".

Give it a name of "Memory" and click "Next"

Now browse to where you want to save the logged data, lets make it easy and drop it into the root of " and then click "Next"

Choose save and close on the next screen and click "Finish"

Now in the left hand side, expand "Data collector sets" then "User Defined" and click on your new "Memory" one we created.

In the right hand screen double click the "System monitor log"

In this screen, click the "Processor" that's already listed and then click the "Remove" button.

Now click the "Add" button, scroll through the list and click the plus symbol next to "Memory". Click on any one of the things in the list to deselect all of them. We are going to individually select jsut the ones that interest us and judging by what you want to see I would hold down the control key and specifically select,

% Committed Bytes in use

Available MBytes

Pages Input/sec

Pages Output/sec

We can start with these and add more if needed later, click the add button to add them to the right hand side.

Now click "OK" then "Apply" and then "OK" again.

Now on the left hand side in the tree, right click your user defined "Memory" and choose "Start".

On the left, expand "Reports">"User Defined">"Memory">"System Monitor Log.blg"

Clicking on that last one should show you your current monitor is running in the right hand side. If we go back to our data collector set on the left right click and say stop, then click again on the system monitor log, we can now see a graph of what is being collected. This same data is also being saved to a log file in the C root which when we open it shows something similar.

In the steps above where we chose what to see, had we left everything selected for memory, it would have been around 30 things it would graph out making it difficult to read.

From here, run it for a week and check your results. It should give you a nice graphical baseline.

Good luck and let me know if you need any further assistance.

-Jay

---

How to interpret metrics collected by Perfmon.

  - Evaluating Memory and Cache Usage
  - http://www.sqlshack.com/sql-server-memory-performance-metrics-part-1-memory-pagessec-memory-page-faultssec/

For memory usage, the most important counters are pages/sec and page_faults/sec.

pages/sec is the sum of input/sec and output/sec. The normal range is 40-150/sec.

page faults/sec can include both hard and soft page faults. The normal range is 10-15/sec. But it can be as high as 1000/sec sometimes.

To decide if there is a short of memory is more complex than just looking at these numbers. You also should take into consideration the reads/sec etc.