October 22, 2015 at 4:07 am
Hi there,
Does anybody know of a way/tool/utility I can monitor multiple database behavior?
I am using sql2012 with partitiondb custom installation[/url] over 6 dbs on 4 servers, ~200GB per db.
I am looking for the perfect graphic tool (similar to Perfmon+Activity Monitor) where I can monitor a wide-scope SQL environment. I am interested in data / log / table / index growth, buffer cache hit ratio, average wait time, physical/logical reads/writes and such. I am interested in real-time / time-range metrics. I know I can issue immediate queries against dm_os_performance_counters / dm_os_buffer_descriptors / dm_exec_query_stats and get some of the relevant data, but is this the only way?
Also, for your opinnion, what are the most crucial metrics to monitor when dealing with multiple dbs?
October 22, 2015 at 8:20 am
This really comes down to opinion and your personal preferences, but I can recommend Redgate SQL Monitor [/url]for taking care of what you describe. It covers all the metrics you've asked for and quite a few more. You can even see how we're using it to monitor this web site, SQL Server Central, in real time by visiting this web page[/url].
The other monitoring tools that people are going to come along and mention are all capable of doing what you're asking for as well. My suggestion is that you download each of them and evaluate them within your environment to see how they meet your needs.
DISCLAIMER: I work for Redgate.
"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