Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Log Shipping and the Monitor server

Author  Topic 

CanadaDBA

583 Posts

Posted - 2006-02-17 : 13:43:33
How critical the monitor server is? Does it have too pressure on my primary server if I use it as both primary and monitor server? Any experience?

Thanks,

Canada DBA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-02-17 : 14:50:43
We have two different sets of log shipping servers. On our non-clustered set, we put the log shipping monitor on the primary server. On the clustered set, we installed a default instance which is not used by any of our applications. It is more for the DBAs to use. That is where we put the log shipping monitor for this set.

We haven't experienced any performance problems with the log shipping monitor. It really doesn't do too much anyway.

Tara Kizer
aka tduggan
Go to Top of Page
   

- Advertisement -