thanks Ted, it worked for me as well....now to find out who is growing my tempdb 1 AM in the morning to rediculas sizes ..

Morning

I am experiencing the same issue , have you manage to find the problem ?..

Hi Mike

No need to appologize did nothing wrong, I just find that sometimes people look at SQL Server as the little brother and I get very frustrated because of this(not...

If any one that think's SQL is less complex then Oracle or DB2 then I would assume you have excessive knowledge in these products to make such a decision. Then...

Great Article, Since most DBA's responsiblity is supporting\troubleshooting such a complex product like SQL server you have highlighted a good methodology and approach to problem solving, Thanks ! 😉

Hi

Please send your results of select * from sys.dm_os_wait_stats

or

select * from sys.dm_os_wait_stats

where wait_type = 'SOS_SCHEDULER_YIELD'

I think the reference gives you clear indication as to why you need to do it.

Just picture this ..8 way machine with high workloads and many statements initiating a...

Hi

Yes you can set the cost threshold , but even when you do initiate a degree of parrallelism opertion you do not want to effect all the schedulers and...

Hi

I have a newly build sql server cluster and getting these errors with no application volume at all.

As a best practise

configure maxdop on half your cores

so if oyu have 8 cores in the server make maxdop 4 or less.

If you have hyperthreaded CPU's...

is this just updating data ?...so inserting , deleteing and retrieving is acceptable ?

You will have to find out why SQL is 100% ....

In profiler use your own templete and...

another vote for the book.

You could use DTA , but just be carefull to get to familiar with DTA , some people use it because they are to lazy...

Hi

have you read this?

http://support.microsoft.com/kb/918483

and here is our beloved PSS engineers response as well

http://blogs.msdn.com/psssql/archive/2007/05/31/the-sql-server-working-set-message.aspx

hope this helps

Hi

Hmmm waittypes and queue's very important to understand and if you do then it is a great performance tuning factor ..

Looking at your list of waittypes it is relatively...

I agree with Gilamonster (whatever the name is)

Look at the waittypes and waittime while executing the sql statement ..the Optimizer might not even use the non clusterd index and did...