Jack,

I'll ttry a smaller filesize, I used 50 Mb.

The other way is crude but simple: I scripted the trace and ran it in a job. Had to stop the trace...

Hi Kruti,

There is no inner SELECT, the statement is as I have given. There are some more columns, but that is not important, only the SELECT COUNT(1) is executed. The...

Jack, I run profiler on my local pc with WXP, servers are W2003 EE with SQL2K5 SE. I believe it to be the known bug existing in SQL2K; if I...

Ah, it is, but not in a format I expected: OS maximum instead of a fixed number.

Tnx.

Sorry for the delay.

There is no WSRM in use; max degree of parallelism is set to 0, meaning it will use all 8 CPU's.

We're checking things out and hopefully monday...

Hi Florian,

Worked like a charm, tnx!

I always thought those arrows had something to do with direction...:hehe:

Tnx.

Found some similar stuff myself, but your's more detailed & extended.

Tnx again.

easyest way is to use sql server profiler.

Create your trace with all filters (db) you want and script it.

Then launch it in a startup job or procedure.

Got that part, but...

Very educational article. Lately I have to deal with performance issues created by similar queries as given in this article. I like to read more about subqueries and their alternatives....

Tnx for answering all. Found out about SQLPERF already, but tnx anyways.

Tnx Sunny, works like a charm, and it's a better solution then what I had in mind.

Still I would like to know what I should select in Profiler to get...

Hi Florian,

I will try this monday, when I'm back at work. Exactly on the icon. Got it.

Tnx

Hi Alz,

The server is a dedicated SQLServer box. Can't check on WSRM, it's a long holidayweekend here in the Netherlands. I'll check monday.

Hi ALZDBA,

I considered some of the things you mentioned. The strange thing is, these 2 CPU are constantly (much) higher then the other cpu's. They follow the same frequencywave as...

Florian,

I checked all these items and no, there was nothing indicating why this behaveour occurred. SQL Server can use all 8 CPU's.

Tnx for answering.