Post reply

Activity monitor history

  • December 5, 2014 at 9:07 am

    #312953

    Is there a history table for activity monitor in 2014? Is there a way of going back to find out how many users were connected to a database server at a particular time or check the processor time for last 2 hrs etc?

    Thanks

  • December 6, 2014 at 3:50 am

    #1763113

    Nope. That's an active log based on stuff currently occurring the system and things in cache within certain dynamic management views within the system. If you want to track those types of counters over time, you either have to build your own mechanisms for capturing them or look to a third party monitoring tool.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply