I should also say that they did recomend not running traces unless you have to or unless it's the default trace.

me too, we run them constantly out here. I know how to save the trace definition as a template, but I don't think you can just attach that here -...

OK, we have found the problem. I would like to thank everyone who posted on this topic, there were some really great suggestions and I learned a thing or two....

we have thought about adding with recompile to that sproc. I'll talk to my team and see if we want to try that. Will post results. I have the results...

there does seem to be more reads going on when the problem occurs.

when we look at the plan, it doesx switch back and forth between 2 different plans. they...

here is the output from sys.dm_os_waiting_tasks while the problem is occuring

wait_type ...

I don't claim to be a trace expert, but I think I have been pretty thorough with them. something I can note here that does point towards SQL and not...

good suggestion. I'll try that next time we get the bahavior and post the results

it only seems to affect 1 database. users affected are about 7 out of 150. apps affected are 3 out of 150.

basically it's just a huge slowdown. a query...

the problem just occured again, so growing tempDB didn't seem to have an impact.

the data file is about 13GB, 6GB free space, set to grow by 25MB, but I just...

FHLBRateID is both the identity and primary key

I can't seem to find the page split, can you tell me where to find that?

CREATE TABLE [dbo].[TableName](

[col1] [int] IDENTITY(1,1) NOT NULL,

[col2] [int] NOT NULL,

[col3] [int] NOT NULL,

[col4] [int] NOT NULL,

[col5] [int] NOT NULL,

[col6] [decimal](10, 6) NOT NULL,

[col7] [decimal](10, 6) NOT NULL,

[col8] [decimal](10, 6) NOT...

we found an answer to our perfmon problem with the missing sql counters - since we are running x64 windows and 32 bit sql, we need to run perfmon with...

the problem is not isolated to a certian user. The performance counters are truely missing (microsoft confirmed and they are working on a way to get them installed). I'll definitely...