How do I get a graph of request traffic history in MS SQL Server 2008 R2 We're having difficulty with an application. One of the potential causes on the table is a regular spike in database traffic overloading the database, causing DB-dependent services to back up.

I would like to get a graph of the number of requests received per second over the last several days, and can't figure out how to get Server Management Studio to give me one. Or any historical performance graph, for that matter. Plenty of performance reports but none of them showing differences over time. Is this something it can't do, or am I just not looking in the right place?
SQL server doesn't track that information historically.

Going forward, you'll have to do one of the following:


Set up a PERFMON trace on the server with the appropriate counters
Set up a custom SQL agent job that queries the current values and stores them in a table
Use a 3rd-party SQL monitoring product, like Solarwinds DPA or something like that.