Editing your post to delete the question and leave "Fixed" in its place removes the ability for this thread to be searchable by someone else having a similar issue in...

How is SQL Server configured to use memory? What is the max/min server memory set at? Is the service account using Lock Pages in Memory? What is...

There are a couple of things you could look at. If the bottleneck is not PFS contention and is instead a diskio problem, sys.dm_io_virtual_file_stats() would be a good thing...

I'd personally go the route that Elliot first proposed and use SQL Agent with CmdExec tasks and then use sp_start_job in a certificate signed wrapper stored procedure. Using the...

The first thing would be to validate that your hardware supports SCSI-3 persistent reservations commands which are required for clustering Windows 2008.

Windows 2008 Failover Cluster Validation Fails on...

Geoff Hiten explained how to do this on a MSDN Post:

You can do this, it just takes a bit of downtime.

Here are the steps:

Begin by provisioning the new LUNs and...

With a cluster, I am with Jason on this one. You should be using the Cluster Administrator to handle the stop and start. How often do these maintenance...

To figure out how the UI gets the information, start a trace against the server, restrict it to your login name with a filter, and make sure that the SQL:Batch...

Paul Randal has blogged about the 1 file per cpu with tempdb in the past. You can read his thoughts on this at:

In Recovery... | Search Engine Q&A #12:...

This sounds like a process issue to me. When the data gets inserted where is it coming from? An Application, a Adhoc user request, a bulk upload from...

Rather than do this in a trigger, I'd probably go the route of using a OUTPUT clause to get the inserted information and the pop the necessary information into a...

Grant Fritchey (12/3/2009)

---

A threshold of 5 is extremely low, especially for an OLTP system. I'd suggest bumping it up to a higher number. I use 25 as a starting point...

GilaMonster (12/3/2009)

---

Kwisatz78 (12/3/2009)

---

Ok this is where my understanding is weak, how can I see what queries have CXPACKET or SOS_Scheduler_yield waits? and further to that how do I then...

My only problem with this is the TRUSTWORTHY ON part. There are so many other ramifications associated with that beyond just allowing your External_Access CLR procedure to execute. ...

That's the first article I just sumbitted to SSC...