For most out there the issue is they don't know what they don't know. I see the same suboptimal stuff (in ALL respects - config, mx, design, architecture, schema, code,...

ARC211 (8/26/2015)

---

With that being said, what is the problem with conducting the testing on a test db that is not part of the mirroring session. If it's an exact...

If you think carefully enough about the reason(s) why locks are taken in the first place then you would easily realize that what you ask would break those reasons/requirements.

I would hire me to come in and give your systems/servers/apps/processes a review!! I would follow-up with some mentoring too! 😀

Presumably because the objective of this test was to make sure the application (and lots of other stuff) are done right and operate correctly after a mirroring failover. This is...

Eric Mamet (8/26/2015)

---

I tend not to like that one because I find it too complicated and sometimes looking like a black art.

I have not seen installations running smoothly without...

At first blush I don't think this is possible.

You didn't give us any error messages. Can't help or advise without...

Eric Mamet (8/25/2015)

---

Might be what we need...

If I understand properly, the Secondary databases are available for reading but not during restores...

Could you point me to where I can find...

Obvious question: What changed?? Note that with unknown storage and virtualization in play there are umpteen places you need to look for "changes".

Log Shipping is cheap and easy AND Standard Edition!! I have been using this every since it first came out. STANDBY mode on the restores allow you to have read-only...

Locking/blocking from a large transaction was the cause. Glad you had a simple fix! 20X improvement is AWESOME! :w00t:

A) I don't think you understand what I meant with my (re)compilation issues statement. Not that plans are changing but that frequent (re)compilations are causing slowness. But I suppose plans...

owl83 (8/21/2015)

---

Hi everyone!

I've encountered strange behavior of server cursors.

We've got an application which reads data from MSSQL DB (MSSQL 2012) using cursors most of the times.

Each night we are running...

I can't possibly help you with syntax for a query without table create script, sample data and expected output.

in general it will look like this though I think:

select field1, field2,...