I think this is fixed.

We have found that the CPU settings in the bios were set to balanced

Thanks SQLRNNR for the pointer.

A 'real' workload before changing the setting now takes...

Thanks for all the responses, I will try to answer/respond to them all.

in my small test to see a reproducable negative difference, I am doing a select * from a...

If we rebuild the indexes on the table, then all is well again but we are having to do this every day, to 'handle' the problem.

Wedo have overnight tasks to...

Thanks for the replies, much appreciated.

I have now reduced it to 6 from my 'temp' setting of 12, it was previously the default, 0.

CXPACKET has now dropped from about 170...

Thanks, but we are not using that member of the dynamics family (we use NAV which is even more cursor heavy) but the 'concepts' still apply.

Amazing, good guess 🙂

Thanks for the pointer, I'll read through that.

Normally I find it is a single process which is easy to spot/fix.

Rather than 1 process, it seems that FETCH_APICursor is recorded thousands of times so the cumulative effect is total CPU.

In SQL profiler, this shows as cursor fetch etc. but for...

Good idea, I have notw tried that and have displayed the parameters onto the report and they match the paremeter section, which means that after the initial selection they are...

Nope, in Transact-SQL, a timestamp is a special binary field. so looks like this 0x00000000000007DA

It is also called 'rowversion'

This field gets updated every time the row is modified, so I...

We are only using fuzzy lookup in an SSIS package which we could move to a new group server dedicated for BI. As our current server has 128GB RAM...

Thanks for the replies we will look at the possibility of removing one processor, one of our next options failing that then would be to 'downgrade' to Standard Edition, is...

Hi,

Yes I am asking/insisting for this (as their is a fussy line as to responsilbilites due to geography and where its a SQL or infrastructure issue) the last reply I...

Hi Gail,

I have an update from my hardware guys.

The D: drive is very fragmented and chdkdsk failed, so their solution is to create a new LUN on clean disks format...

thanks for the reply.

Yes the times this has been noted is during an maintenance task that rebuilds indexes and when new application objects are deployed/compiled.

So my understanding is that we...