December 5, 2017 at 12:37 pm
Is it possible to combine the Activity Monitor Overview from a number of servers (6 in my case) onto a single screen, i.e. there'd be 6 rows each with 4 real-time charts?
December 5, 2017 at 1:13 pm
rchantler - Tuesday, December 5, 2017 12:37 PMIs it possible to combine the Activity Monitor Overview from a number of servers (6 in my case) onto a single screen, i.e. there'd be 6 rows each with 4 real-time charts?
I don't believe so - you would need to write an application to do this.
A different option would be you could use CMS and execute queries across all of the servers to capture information.
Sue
December 5, 2017 at 1:50 pm
Thanks. Options are good!
December 5, 2017 at 2:41 pm
rchantler - Tuesday, December 5, 2017 1:50 PMThanks. Options are good!
Register all of your servers to use Central Management Server and then do a multi-server query. There are a few scripts posted doing the same thing and some others have recommended using sp_WhoIsActive.
You can find a discussion on this, some sample scripts, links to sp_WhoIsActive, etc in this thread - it should help you get started :
How to get the SQL Server Activity Monitor's output using T-SQL?
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply