Sql Monitor 4 server side or client side tool?

SQL Server performance monitoring and alerting

Moderators: Colin Millerchip, priyasinha, Adam, chriskelly

Sql Monitor 4 server side or client side tool?

Postby preetshari » Tue Mar 11, 2014 5:09 pm

Is Sql monitor 4 a server side tool? We currently use sql profiler which is a client side tool, hence we see performance degradation when monitoring with this tool.
preetshari
 
Posts: 2
Joined: Tue Sep 17, 2013 6:56 pm

Postby TheLonelyDBA » Tue Mar 11, 2014 8:29 pm

I believe SQL Monitor does not compare to Profiler.

Profiler is really hard on the server, because it will keep track of *everything* that it logged. SQL Monitor will only poll the server every few seconds to request the information it will store.
Tips and thoughts on MS SQL, Oracle and MongoDB:
http://thelonelydba.wordpress.com
TheLonelyDBA
 
Posts: 18
Joined: Wed Oct 30, 2013 8:01 pm
Location: Brazil

Postby Colin Millerchip » Tue Mar 11, 2014 11:41 pm

Hi,

Just to confirm, SQL Monitor does not need to install anything on the machines / SQL Server instances that you are monitoring.

For more information on SQL Monitor installation, please see the documentation here:
http://documentation.red-gate.com/display/SM4/Installing

Thanks,


Colin.
Colin Millerchip
 
Posts: 66
Joined: Wed Oct 31, 2007 5:31 pm
Location: Cambridge, UK


Return to SQL Monitor 4

Who is online

Users browsing this forum: Richtpt and 0 guests