July 19, 2010 at 10:42 am
Is there a history table for activity monitor in 2005? Is there a way of going back to find out how many users were connected to a database server at a particular time?
Thanks
July 19, 2010 at 12:32 pm
I don't believe there is in 2005. In 2008 there is the management data warehouse, which should capture this.
July 20, 2010 at 5:49 am
But even the management data warehouse has to be enabled and the data kept in order to go back in time to retrieve it.
Basically, the answer is, unless you've set up some mechanism (built in to the product or not) to retrieve this information and store it over time, no, you can't get at it now.
"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 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply