jasona.work (8/15/2013)

---

Oh the unfettered joy and terror of that "oh sh1t" moment...

The one when you realize / find out that the DB you just restored into production from QA was...

jasona.work (8/15/2013)

---

Jan Van der Eecken (8/14/2013)

---

jasona.work (8/14/2013)

---

Ed Wagner (8/14/2013)

---

jasona.work (8/14/2013)

---

Ah, so much fun being on a contract job...

"We've got a bunch of hours to spare, do you want to work...

Erland Sommarskog (8/14/2013)

---

The data you see...

I turned on logging in the SSIS package. I set it to log everything. The package took 18 minutes and 25 seconds to run for its 3:30 AM run last...

Erland Sommarskog (8/14/2013)

---

Ah, so you have a stored procedure. In that case, there is a somewhat simpler query:

with cte as (

select substring(est.text, (qs.statement_start_offset + 2)/2,

...

Erland Sommarskog (8/14/2013)

---

Ah, so you have a stored procedure. In that case, there is a somewhat simpler query:

with cte as (

select substring(est.text, (qs.statement_start_offset + 2)/2,

...

Erland Sommarskog (8/13/2013)

---

I think you should invest whether the query plan at the problematic point in time is a fresh one or a new one. You can use this query...

HowardW (8/13/2013)

---

Stefan Krzywicki (8/13/2013)

---

L' Eomot Inversé (8/13/2013)

---

The things you're not...

L' Eomot Inversé (8/13/2013)

---

The things you're not doing definitely include...

HowardW (8/13/2013)

---

SQL Trace and Perfmon on the guest are only showing you part of the picture.

Even if you've gone for a 1 to 1 mapping of host/guest, these are the...

If anyone has any ideas about this odd problem, I'd be happy to hear them. I've updated the post with our latest status.

OK, I have some more data.

We stopped all backups of all kinds across the entire system. That's not it.

We're using Windows Server 2008 OS Standard. This limits us to 32Gig...

jasona.work (8/12/2013)

---

Well, in a little over an hour, I'm going to be picking up my shiny new BRZ...

Went for a test ride on Saturday, chewed over all the pros and...

Brandie Tarvin (8/12/2013)

---

wolfkillj (8/12/2013)

---

Brandie Tarvin (8/12/2013)

---

Jeff Moden (8/10/2013)

---

Brandie Tarvin (8/2/2013)

---

How many people (besides Jeff and myself) have written SQL Spackle articles?

How many SQL Spackle articles are there?

Yes, I have a...

Ed Wagner (8/12/2013)

---

ChrisM@Work (8/12/2013)

---

Stefan Krzywicki (8/9/2013)

---

L' Eomot Inversé (8/9/2013)

---

ChrisM@Work (8/9/2013)

---

dwain.c (8/9/2013)

---

ChrisM@Work (8/9/2013)

---

Port Moresby - ranked 139th of 140 cities for liveability, whatever that means. I wonder which city came last?...