How do you use cloud databases? Take the survey.
Options

SQL monitor installed directly on monitored server VS installing elsewhere with access to server

sqlmonitorsqlmonitor Posts: 1 New member
in Redgate Monitor
Hi,

Can anyone advise me on the advantages/disadvantages to both of these scenarios? And which is best practice.

Thanks
· Share on Twitter

Answers

  • Options
    cfendrickcfendrick Posts: 15 Bronze 2
    Best practice is going to be install elsewhere and not on the SQL Server, ever. 

    Disadvantages is that SQL monitor takes some resources and if the server is down then monitoring is down.  In a high performance production scenario any and all resources should be dedicated to SQL.  

    Only advantage and the typically use case for installing monitoring on the server itself is a cost saving measures in my opinion.  It could also make for a smaller footprint by having 1 or 2 less VMs/Servers. 
    · Share on Twitter
Sign In or Register to comment.