Anything that is Serverview is not a MS SQL product. They are 3rd party apps being installed into SQL server. As for the service names with Serverview in...

Just a hunch, are you seeing contention in tempdb?

http://blogs.technet.com/askperf/archive/2008/03/25/lock-pages-in-memory-do-you-really-need-it.aspx

http://msdn.microsoft.com/en-us/library/ms190730.aspx

Also, setting up tempdb properly can ease some of the performance problems you are seeing.

The issue must have resolved itself

You're welcome.

I was leaning toward the Correct answer until I re-read the question and convinced myself that it was asking for server performance. I would have to agree with Peter...

It seems similar to this other thread.

http://social.msdn.microsoft.com/Forums/en/windowstransactionsprogramming/thread/3b6ab6e7-bc17-4aec-b521-0ed33e91dc8d

Specifically look into xp_servicecontrol

What version of SQL and OS are you running?

When you installed DTC, what was your procedure?

Where do you see that DTC is running/not running (Service control panel or Cluster Administrator)?

WayneS (12/14/2009)

---

Alvin Ramard (12/14/2009)

---

GSquared (12/14/2009)

---

CirquedeSQLeil (12/11/2009)

---

By the time the thread hits 10,000 y'all will be flatlined, passed out drunk from all the bear being passed around - bwahahaha 10,000 shall...

jcrawf02 (12/14/2009)

---

crookj (12/14/2009)

---

CirquedeSQLeil (12/11/2009)

---

Yes, yes indeed that is humorous:-D. Too bad my...

OK - I disagree with the current answer. Though there are 3 select queries to retrieve the results - the recursive query is two select statements.

Maybe it is nitpicking....

Lucky guess - Image would not display.

What is the difference between this question and the question for 12/27/2004?

Different answers are correct, so which of the two is more correct?

What is the difference between this question and that of Feb. 16, 2005?

One says that you must use a wrapper, the other says that the wrapper already exists and nothing...

Just tested the query in SSMS 2008 and it produced the same results as 2000 QA.

What is your disk configuration and tempdb configuration?