swash

Based on all of this, can you provide DDL and DML that would reproduce the issue? Since the issue occurs when running the stored proc alone, there is no...

Jeff Moden (7/17/2014)

---

From what I've seen, Grant Fritchey's recommendations for changing the default threshold of parallelism are much more effective than changing the whole server to use MAXDOP 1. ...

What does the inner FOR EACH LOOP container do? How is it configured?

Is there something else other than a select statement in that proc? Trying to gauge if nolock is used in the proc at all.

And back to Jacks question about...

PHYData DBA (7/17/2014)

---

We smiled and waved, they literaly bit the waving hand.

Then after showing them some information from Paul Randal, and from some Issues with a WellPoint Datawarehouse.

They asked us...

Jack Corbett (7/17/2014)

---

Sean Lange (7/17/2014)

Sadly I will not. I need to find a way to get to one though. It is a large chunk of change for me...

rNA

Sean Lange (7/17/2014)

---

SQLRNNR (7/17/2014)

---

Sean Lange (7/17/2014)

---

I assume that Summit will be in Bellevue or Redmond. That makes for a length bus trip. Depending on how you hit the timing it...

A good response for this vendor would be to Smile and Wave.

No need changing a setting when it likely won't improve anything. Not under the described circumstances.

Try this article

http://www.mssqltips.com/sqlservertip/2785/changing-sql-servers-default-snapshot-folder-for-replication/

Are you by chance using NOLOCK in your stored procedure?

That's great for the vendor. But that is an apples to oranges comparison coming from them.

Is the workload high OLTP? Or do you have you noticed parallelism being...

+1

Sean Lange (7/17/2014)

---

I assume that Summit will be in Bellevue or Redmond. That makes for a length bus trip. Depending on how you hit the timing it could be an...