Jeff

Have you consider decaf?:w00t:

David

Your management has put in you in a horrible spot where you'll get no credit if it goes well and will get the mess\blame if it goes badly. ...

I'd recommend verify that that database is owned by the user you'd expect.

What is the actual differences in reads between good and bad performance? Jumping between a merge and a hash would makes me think the plan is not scaling...

When you the procs run longer are the reads and writes the same as the short run?

It seems you have reasonably eliminated IO and general performance possiblities. The service starts does a varity of things from flushing users, memory, and clearing temp db etc.

Since a restart...

So there isn't any indication of an IO spike during the incident, hmmm.

Can you describe again what is happening during an incident and how long its...

OK, it is not likely page splits then.

Let's review since we've gone back and forth on this

1. Has the problem happened since Tempdb was grown?

2. How...

IF FHLBRateID is your primary key and not your identity column that would make the possibilty of page splits being more likely. If FHLBRateID isn't the identity and...

Sql Server:Access Methods

There is a profile measure for page splits, you should look at that given your insert description

Can you list the structure of the table? How are you managing...

To see the counters you have to be admin on the server I'm pretty sure so that might be the issue.

Are tracing the Sql? Since you can isolate the...

< 1 gb is a small tempdb unless this is small non-oltp system. Since it is a cluster I doubt that is the case. You can...

My first suggestion would be to see how your tempdb is sized? If the user is doing something that uses a lot of tempdb space you could be waiting...

Most of them are pretty good but you got two I'm thinking could be a problem.

If you've go the maintenance window. I'd run dbcc dbreindex against the whole...