Marios Philippopoulos (7/31/2008)

---

Carl Federl (7/31/2008)

---

"But I forget what the 3rd number means. Any ideas? " The Page number.

Have you optimized tempdb? See "Concurrency enhancements for the tempdb database" at...

Thanks for...

Thanks for the suggestion. It looks like the contention involves the sysobjects table on both the user and tempdb databases.

Moving the temp table creation and deletion statements outside the transaction...

In sysprocesses table for my SPID I see PAGELATCH_SH as the lastwaittype.

Marios Philippopoulos (7/31/2008)

---

rbarryyoung (7/31/2008)

---

Actually, I can not see why you even need a transaction for this. If everything is in TempDB anyway, why do you need Transactions, Commit or...

Good point.

The...

Carl Federl (7/31/2008)

---

spid dbid ObjId IndId Type Resource Mode ...

Both the data and log files of tempdb are on the same drive location.

Could this be caused by a slow drive?

Thanks guys, I found a link here on SSC specifically for this, which pretty much does what you are referring to:

http://www.sqlservercentral.com/articles/SSIS/61987/

So I'm not crazy after all. I...

thanks, I will go through these steps.

colin Leversuch-Roberts (7/30/2008)

---

it's worth seeking out any high io queries, fixing them ( if they exist ) is a much better solution!

Mind it depends upon database size and so on...

GSquared (7/30/2008)

---

I've had problems getting SQL 2000 procs to distribute transactions with SQL 2005. My solution has been to move the proc to the 2005 server and make it...

Ken Shapley (7/17/2006)

---

"Generally, the rule of thumb is to have as much as RAM as your data file is."

Did you come up with this rule yourself? How many databases...

Does the "Process\Working Set" counter include AWE memory utilization?

I don't think it does.

In my machine it reaches 700,000,000 (700 MB), which is way below the 13.2 GB allocated using...