New answers tagged

3

we'd like to know we're "ok" on resources for the term of the lease. This is a "feeling" now you'll have to put this feeling into tangible, can be tracked and trended. This is how you can make predictions about your workload. What would this look like? There are three areas you'll need to document: What are the limits of my hosted solution? There may be ...


1

On SQL Server 2008 R2 the default value of remote login timeout (s) is five (5) seconds, I believe, though it is configurable. Since you are now trying to connect to an AWS RDS SQL Server, have you considered whether the remote login timeout (s) is appropriate for this environment? Try raising the timeout a bit. You might start with 10 seconds: ...


1

Beware of Split Brain. The tough problem in promoting a Slave to be Master happens when the problem is in the network. With a dead network, most types of monitoring will mistakenly think that the Master is dead and promote the Slave. Now you would have both servers alive and thinking they are the 'Master'. This condition is called the dreaded "split ...



Top 50 recent answers are included