Hello - I would like some help please on an issue I am having on a site. I have found a previous thread (http://www.sqlservercentral.com/Forums/Topic1165211-145-2.aspx).
I have managed to run the queries request here and have confirmed that I am also experiencing the same symptoms
First some brief facts
SQL Server 2005 9.0.4035 - yes I am 1 SP behind - plans underway to patch
max_server_memory set to 26624 MB (26GB)
Windows Server 2008 R2 Datacenter x64
physical RAM is 29GB
I have identified a number of high cpu queries and dealing with those presently - change control
I have regular maintenance underway twice weekly optimizes being run
I have run Ninja's queries and the results are in the attached jpg - sorry can't figure out how to roll txt into the post.
Could someone please confirm that upping the cost threshold higher than 5 as suggested by Grant would help me - along with the query optimization being planned. Right at the moment my task manager is showing me the cpu utilisation and it looks like someone is lying on one of those poly graph tests
Any suggestions would be gratefully received