Check out the function fn_hadr_backup_is_primary. That will tell you if your server is currently the primary. Then, you enable the jobs on all the servers, but it will only run...

Eirikur Eiriksson (9/21/2015)

---

Grant Fritchey (9/21/2015)

---

There are only 38k distinct values in a data set of 25 million. Add to that the fact that you're selecting a broad swath of those...

Without seeing the queries, it's just general advise. Make sure the objects are accessed in the same order. If you're doing reads then updates, possibly try using UPDLOCK on the...

And you can check the wait statistics yourself to see why the backups are taking time. Query sys.dm_os_wait_stats before and after the backup. See what the issue is there.

Please don't cross-post questions. It just leads to confused conversations. Please use this thread for further comments. It looks like you might be happy with one of the answers on...

There are only 38k distinct values in a data set of 25 million. Add to that the fact that you're selecting a broad swath of those values. Assuming an even...

Jack Corbett (9/18/2015)

---

Just got a deadlock alert from Idera DM and this is the query(anonymized):

'

SELECT

*

FROM

"database"."dbo"."table" WITH (UPDLOCK, REPEATABLEREAD)

WHERE

...

This is just a ridiculous and extended troll. Unsubscribing. There's no point to any of this.

PHYData DBA (9/16/2015)

---

erichansen1836 (9/15/2015)

---

Before you upgrade from a file-based database engine to a server-based database engine, you must consider the advantages and the disadvantages of doing so. For more information...

You've put tons of time and effort into this and it sounds like you've done amazing work.

However, tons and tons of the work you've done is just replicating the functionality...

jasona.work (9/11/2015)

---

So, as some of you (or many) may know, I'm currently a contract worker...

Well, in just about a week, that all changes. Last week I put in my...

Actually, yeah. Wild.

Pretty sure this is just a troll. A JET powered troll. Making up your own terms... <sigh>

Then, by absolute definition, it's not a NOSQL...

Lynn Pettis (9/10/2015)

---

If any one is interested in a philosophical debate over the pros and cons of a File System based DB and a RDBMS, feel free. Not really...