Exactly. It should look something like this :

<deadlock-list>

<deadlock...

#1 The links I gave you are exactly to find out the query bottlenecks. So those are extremely relevant to your case.

#2 I'm not perfom expert, not even junior.

However...

Plz post the deadlock graph.

Traceflag 1222 if you don't have anything in the sql logs.

Yes. I actually use this script to pick out which indexes need work. It...

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2

BACKUP.

Integrity is also VIP. Index maintenance is less of an issue.

JG-324908 (9/12/2011)

---

SOLUTION: UPDATE STATISTICS on key table used within the query. My query returned in < 10 seconds where before I was killing it after 10, 20, 30...

Grant Fritchey (9/12/2011)

---

Ninja's_RGR'us (9/12/2011)

---

I'd actually say it's worse, especially in a multi db environement.

Imagine losing 1 out of 100 dbs. It's annoying to very problematic, but if ALL of...

I'd actually say it's worse, especially in a multi db environement.

Imagine losing 1 out of 100 dbs. It's annoying to very problematic, but if ALL of them go offline...

Jeff Moden (9/11/2011)

---

Heh... I could argue all day why it's not RBAR but I'll take the hit, for...

This one's actually much better than DBCC opentran()

Ninja's_RGR'us (9/7/2011)

---

--Borrowed from the activity monitor

SELECT

[Session ID] = s.session_id,

[User Process] = CONVERT(CHAR(1), s.is_user_process),

...

ALZDBA (9/12/2011)

---

Ninja's_RGR'us (9/11/2011)

---

You want lousy week-end?

Try having 2K+ of unexpected repair on your car, having to lose 1 weeks income + all the trouble to be flooded by Irene while...

WayneS (9/11/2011)

---

Ninja's_RGR'us (9/11/2011)

---

You want lousy week-end?

Try having 2K+ of unexpected repair on your car, having to lose 1 weeks income + all the trouble to be flooded by Irene while...

This works only on the indexes that need work.

Fully customizable, including max time.

The max time is checked before doing the next task. So obviously this is not bullet proof,...

You want lousy week-end?

Try having 2K+ of unexpected repair on your car, having to lose 1 weeks income + all the trouble to be flooded by Irene while getting corruption...