June 13, 2018 at 11:43 am
Hi All,
Want to get an opinion on monitoring performance of multiple SQL Server instances on different servers using native monitoring tools like SQL Profiler, Perf Monitor, Configuration Management, Data Collection, etc.
If I have 10 database servers, is it better to have one dedicated server running the monitoring tools separate from the 10 database servers?
Thanks
June 15, 2018 at 10:11 am
It's not better, it's different
One server - single point of failure, depending on being able to connect to the other instances, easier to admin,
On each server - some load interference from monitoring, each server monitors itself if up, harder to admin.
June 15, 2018 at 11:11 am
Thanks, Steve. Just wondering what's the best practice out there. I'm so used to Oracle that I have Oracle Enterprise Manager as a dedicated management tool
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply