temp tables are also created by other processes that perform sorts as part of their operation

If you are using Windows Server 2008 you will have to tweak the firewall:

http://sqlblogcasts.com/blogs/blakmk/archive/2010/01/15/discoveries-with-sql-server-on-windows-2008-server.aspx

I monitor:

hanging spids\agent jobs

failed jobs

hypothetical indexes

disk space

deadlocks

www.datatao.co.uk

Thanks for this advice however I have experienced lost write conditions and a number of corrupt databases when using log shipping with UNC paths. This has only happened once albeit...

Its safer to go for separate service accounts for each instance. that way if you accidently lock out the account you dont have downtime on all your instances. Since the...

Thanks for the response. Our cluster setup is that we have one physical server for the active node and one virtual server for the passive node.

Ideally I would like to...

yes thats correct, one active one passive for the default instance

Yes thats true, the dates in log_shipping_primaries are out of date. It appears like this table is not getting updated.

The servernames listed from @@servername reflects what is in the log_shipping_primaries...