Vijay
asked on
CPU History in SQL Server 2008 R2
How to query last 2 months CPU history using T-SQL in SQL Server 2008 R2?
Unless you've setup this monitoring previously then there is no way to query for items in the past
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The counters are kept only from the last time SQL Server service restarted.
It's your SQL Server instance working the last 2 months with suffering a restart?
It's your SQL Server instance working the last 2 months with suffering a restart?
ASKER
Good information.