I think RAM usage may be a red herring here. Disk IO is not problematic per the OP. I would check page life expectancy in perf mon just...

I think Erland has the definitive documentation on this topic:

http://www.sommarskog.se/arrays-in-sql.html

Grant Fritchey (2/6/2009)

---

Really. When did it occur? When the query had to hit lots of the partitions or is it...

Grant Fritchey (2/5/2009)

---

It's possible for the compile time to be outrageous. We had an 80 table JOIN, plus an extensive WHERE clause that took 45 seconds to compile but only...

Even if you could set at a system level, isolation level is a CONNECTION level setting and is almost universally set by the subsystem doing the connecting as one of...

My comments on tempdb have almost NOTHING to do with SPACE. It is IO PERFORMANCE that matters. I can create a 1TB tempdb on a SINGLE DRIVE these...

Charles Kincaid (2/3/2009)

---

:w00t: And here I keep buying your books to wave around in our ethics meetings! :w00t:

Good, fast, cheep. ...

Can you tell me how much investigation/study did you do about snapshot isolation prior to...

krypto69 (2/3/2009)

---

While doing my testing (inserts are active) i was getting deadlocks and kicked out.

So I added the NOLOCK, that stopped the deadlock errors..so then..

I removed all indexes, and created...

1) nonclustered indexes are NOT helpful if the value you are searching for is not VERY specific (like <1% of the total rows in the table)

2) at 1K/sec inserts, index...

Marios Philippopoulos (1/31/2009)

---

I have a trigger that appears to execute a very large number of logical reads; on one occasion it has hit 73,421,728 logical reads!

There are two puzzling aspects...

I think any discussion on deadlock troubleshooting should reference this blog series: http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

Other than the ol' trigger-firing-itself-due-to-update-inside-trigger-ploy, 2 other questions:

1) any OTHER triggers on this table?

2) is the join column a primary key or unique index value? Looks like cartesian...

I too have used ERStudio for years now. Good tool. It can get expensive, especially if you get cross-platform licenses. If you are sql server only they...

checkai (1/30/2009)

---

I am currently experiencing some issues as well. Attached is a view of task manager on the server.

RAM: 3.25GB

CPU: Intel Xeon 5150, 2.66GHz

Windows Server 2006 Std Edition

SQL Server 2005...