That's a good answer. If you upgraded then some of your default values may not be correct (like Max Worker Threads).

My guess is that if you set both your...

I don't remember where I got this but here is the query I use to get the Signal Wait percentages:

create table #waitstats (

waittype varchar(80),

requests numeric(20,1),

waittime numeric (20,1),

signalwaittime numeric(20,1))

insert into...

We have found on our 64 bit servers (especially our Itanium) that if we leave Maxdop at 0, the server spends a lot of CPU time transferring the load from...

On our 64 bit servers we set the memory to allow 1.5 - 2 GB for the OS as Gail recommended and set Maxdop at 1 or 2. ...

Thanks Gail, that was my understanding also.

Do you still need to enable trace flag -T1118 to enable the uniform allocations feature in SQL 2005 as we did in SQL 2000?

Try this:

SELECT 'ALTER INDEX ALL ON '+o.name +' REBUILD WITH (FILLFACTOR = '+ CONVERT(varchar(20),i.fill_factor) + ', SORT_IN_TEMPDB = ON )'

from sys.indexes i

inner join sys.objects o on o.object_id = i.object_id

...

Are you trying to determine which version you are on?

webrunner (7/14/2008)

In process of trying to identify if particular queries might be the cause, I checked the Default Trace files. I did not see anything in the trace files pointing...

I liked the point of the question and I hope that is not missed. I have seen occassions where the DBA performed a REINDEX in a maintenance plan followed...

Simon, thanks for the explanation. Implicit conversions involving varchar (max) have bitten me a couple of times already. Nice question.

Thanks for the link, that was helpful.

If I would...

I thought this was an excellant question. In trying to figure out the best answer to the question it made me look pretty deep into the topic and I...

It looks like you are running the RTM version of SQL Server. You might want to try installing SP2. Also try to run the same statement directly in Query...