Hi Markus

My storage team are saying everything is 'fine' but that's all I have got to go on. If there is a disk I/O problem I really need to prove...

No, no backup at that particular time. The logs backup every 15 mins but had completed 2 minutes previous to the errors.

Hi Guys

Are there any facts or figures I can provide to support or contradict the CXPackets theory?

I'm unsure where to begin though I have sent a couple of rogue queries...

Thanks Jon. I'll read up on this.

FYI -

max degree of parallelism = 0

Locks = 0

Cost = 5

Query waits = -1

I'm guessing this is the out the box setup as I've...

The top wait on live always seems to be this:

wait_typewait_time_ms

MSQL_XP26126343

I believe this is due to SQL waiting on extended stored procs to complete yet I can't find a process relating...

Regarding the waits, SQL server performance dashboard shows below (taken at 11:20 today)

Wait Category..................Number of Waits..........Wait Time (sec)..........% Wait Time

Parallelism...........................724065872.................6319246.421...............28.06%

Other................................1232197629................5075559.493...............22.54%

Sleep.................................425224734..................4091093.732...............18.17%

Latch................................1642991523.................3378139.014...............15.00%

Buffer IO............................148173427...................2212876.593..............9.83%

I am not sure whether that seems good bad or...

Hi Steve

Thanks for the prompt response. I will read through the article attached.

Given that I see nothing but expansion in the future, it sounds like I can tweak queries and...