That seems to have been missed. Sadly it is MANAGEMENT/LEADERSHIP that is forcing these ridiculous requirements, not some Jr....

Steve Vassallo (4/29/2015)

---

Our company was just acquired by another. They DBA team there added some jobs to our servers and one was a DBCC Shrinkdatabase command followed by a...

Lynn Pettis (4/28/2015)

---

From the original post:

- Identical hardware between principal...

Oh, the MOST obvious possible cause: Your Secondary is a fraction of the power (CPU/RAM/IO/etc) that your Primary is!! :hehe:

What form of troubleshooting did you do on the database server itself??

1) use sp_whoisactive to find causes of calls not completing in a timely manner (locking/blocking, system processes running, query...

Igor Micev (4/28/2015)

---

Grant Fritchey (4/27/2015)

---

Yeah. I'm...

Can you please explain that statement Igor??

MANY things could be at fault here:

1) triggers doing bad stuff

2) constraints doing bad stuff

3) blocking by other activity (I go with this by default for a 60K row tale...

BEWARE the Scalar UDF though!! It has MANY downsides, including voiding the use of parallelism, preventing accurate estimates but the optimizer (with associated bad performance and bad concurrency), often forcing...

What is the table definition?

GAH!! That's what I get for (again) trying to answer questions with significant jet lag! 🙁

In addition to what Gail offered, there are a number of options for DBCC PAGE, and I think you can get a more detailed set of output that could be...

As long as when primary and secondary are running the SQL Server service and SQL Agent are running they will fire their respective jobs and do what they are supposed...

Stan_Segers (4/15/2015)

---

Oh, this will so much be a great learning experience..

@kevin, hopefully your jet-lag will quickly fade... I very much care about those details. The current SQL 2012 is at...

I came across one person that had substantial problems with row-by-row processing on SQL 2012. I am severely jet-lagged at the moment so I can't remember the details, and could...