Bhuvnesh (10/8/2013)

---

while you insert value ( '16923951 0' ) into it.

it will throw error like "String , binary data would...

Jeff Moden (10/8/2013)

---

Heh... that's likely why things have been such a problem in the past. Thanks, Gail. I wasn't going to get involved in the problem but now...

Again not what I was asking.

Are you seeing executing queries that are getting suspended with latch waits? Are these latch waits directly causing performance problems?

There will always be latch waits...

What if you're not using SSRS?

Oh my, that is horrid cluster design. Nothing but nothing should ever...

Gerard Silveira (10/7/2013)

---

@Dhananjay,

From Windows explorer the only directories I see are the MSCS and MSDTC, there is nothing else that I can see that could be steadily eating up the...

Jeff Moden (10/7/2013)

---

GilaMonster (10/7/2013)

---

Jeff Moden (10/5/2013)

---

I have a similar problem that turns out to be some rather inefficient code that truncates several very large tables and reloads ALL of the...

The way you change column names in a table is with sp_rename. There's no command that automagically changes the column...

Please note: 3 year old thread.

No latch waits in that list, but that wasn't what I asked.

Have you seen queries executing that are suspended with latch waits? If so, what were the wait resources and...

So for some reason the procedure's not committing the transactions that it starts, or it's starting within a transaction already. That means the locks are held until the connection is...

Could the procedure's execution be leaving open transactions?

Problems as in noticeable slow queries due to latch waits, not a counter that's higher than some random person on the internet said it should be.

If so, what latches are...

First things first, are those latch waits causing problems?

One execution of the procedure can block other executions of the same procedure, but it's not blocking itself, there are different session IDs...