This sounds all too familiar if you mix my current place with my last place.

Some amusing additions from my last place could easily be added though.

nHibernate spewing out a minimum...

I have seen one of those limits breached a number of times. It's the number of parameters (2,100) which applies to any query.

Amusingly I've had developers complain that this is...

I was working on some calculations yesterday around latency and different types of storage. Using some 'typical' figures you would see SATA being around 40 milliseconds of latency, SAS would...

Really good article Dave and something we've spoken about in depth a lot over the last few years.

Something worthwhile pointing out on the cost front, PCIe storage is the cheaper...

This is the bit that confuses....

http://msdn.microsoft.com/en-us/library/hh270278.aspx

The diagram at the bottom indicates that my initial idea of a clustered instance at each site might be possible. It's probably me...

for the purposes of my question, don't worry about storage. I can solve that quite easily once I know how to set the DB's up.

Ta

For amusement when reading another topic (http://michaeljswart.com/2011/12/cxpacket-whats-that-and-whats-next/) I decided to run that against my DB that gets hit by the nHibernate queries.

In short the above post gives an...

rough example as it's nearly lunchtime

nHibernate version

==================

(this is roughly what it comes out as - made slightly easier for reading)

DECLARE @p0 INT --etc...for each param

SET @p0 = 1234 --and so...

Great article as always Dave. When you spend a lot more time with nHibernate there are plenty of interesting/challenging things to find. I forget the details now but when we...

Partitioning is the main feature followed by online index work. I'd happily pay for Standard Edition and then an extra fee to plug in the features I wanted if needs...

I currently use Quest's spotlight as the main monitoring tool. We're currently in the middle of a proof of concept for Foglight and Performance Analysis (both front end and back).

Spotlight...

Andrew,

Our distributor is clustered (active/passive) so that answers some of the issues we needed to solve for that side. That leaves the shared disks as the single failure point but...

Sussed it. I set the (bad) copy to offline and then dropped the DB. Everything is as it should be and I can start to put the mirroring back on...

I think I've sussed this.

I'd made a change to the location of one of the files before I failed the mirror back over. It's taken a hell of a long...

quick update.....

On what was the principal, it shows as (Restoring..... - with no mention of the mirror) I can bring up general properties and that's it.

On the mirror (as it...