Well. Hrm. I guess I'll just ramble then and we'll see what we can see.

Based on what you've told me there is conditional routing of clients to multiple presentation points...

So you have a single routing/load balancing point making this decision?

4. So how do you decide which of your users get pointed to the west coast app tier, and which get pointed towards the east coast app tier?

Ok, then my next question would be:

3. Are the application tiers on the west coast and east coast exposing the same application? Or is it that some of the apps...

Two things off the cuff.

1. Usually when SQL tells me I'm trying to connect to null it makes me edgy (or connect AS null as well). But if you're using...

Never a problem. 🙂

Couple of things. And I'm totally not trying to be a smart alec.

1. Your physical drives grow... daily? Or are you speaking to overall data consumption rates of the physical...

Speaking directly to that, in case others run into it...

You must ensure that the security context of the process running SQL Server has the right "Lock Pages in Memory" on...

I would just like to make sure I am understanding you correctly since you appear to be alluding to performance, business continuity, disaster recovery and high availability all at once.

1....

Uh oh. Collation.

Well, there's not really a happy, shiny answer for you on this. This is why my teeth itch when people monkey with collation (and they don't have to)....

Exactly. Tempdb is also SQL Server's scratch pad for various work it needs to do in aggregations, joins and other work. There will always, always be things laying around in...