Stefan Krzywicki (3/24/2011)

---

Grant Fritchey (3/24/2011)

---

Gianluca Sartori (3/24/2011)

---

Grant Fritchey (3/24/2011)

---

Gianluca Sartori (3/24/2011)

---

Grant Fritchey (3/24/2011)

---

Roy Ernest (3/24/2011)

---

You all really think Boston and SA is on top of the list of bad traffic?...

mtillman-921105 (3/24/2011)

---

Grant Fritchey (3/24/2011)

---

It runs one way in the datawarehouse and one way when you call it using EXEC. Are these two different applications making the call? If so, I'd...

I'd run a server-side trace to see what kind of queries are being run to understand why I might be getting intermittent time outs. That or look to see if...

Brandie Tarvin (3/24/2011)

---

USE SSC;

SET SnarkFactor = ON;

GO

Wow. I remember when Oklahoma was actually worthy of being a football rival for Nebraska....

But if some other app pages into memory, it's going to impact SQL Server, and hence the problem you're hitting. I'm not surprised. You're basically in a tough spot. You...

Gianluca Sartori (3/24/2011)

---

Grant Fritchey (3/24/2011)

---

Gianluca Sartori (3/24/2011)

---

Grant Fritchey (3/24/2011)

---

Roy Ernest (3/24/2011)

---

You all really think Boston and SA is on top of the list of bad traffic? You should check the...

Yes, but index fragmentation and statistics being up to date are two very different things. You can have very low fragmentation and statistics that are quite old. You're dealing with...

Ah, so, there are other apps running on the machine? That's more than likely the issure, right there. SQL Server does not like to play well with others. In almost...

Gianluca Sartori (3/24/2011)

---

Grant Fritchey (3/24/2011)

---

Roy Ernest (3/24/2011)

---

You all really think Boston and SA is on top of the list of bad traffic? You should check the traffic in India. Especially...

yes, you can always go and get it from codeplex.com

Have you looked ath this documentation from Microsoft? I'd start there.

Are there other softwares or utilities running on the machine?

Jeff Moden (3/24/2011)

---

Oh, very cool... I just found out that one of my favorite novels is going to be made into a movie. "The Martian Tales of Edgar Rice...

Roy Ernest (3/24/2011)

---

You all really think Boston and SA is on top of the list of bad traffic? You should check the traffic in India. Especially Calcutta. Forget the taxis,...

Jeff Moden (3/24/2011)

---

Oh, very cool... I just found out that one of my favorite novels is going to be made into a movie. "The Martian Tales of Edgar Rice...