My post wasn't clear

Current Index,

Covering Index Columns

A,B

Included

D,E,F

Missing

Index Column

A

Included

D,B,E,F

GilaMonster

I thought the same the query should be covered by the index in place.

is the query slow, everything is slow, I have...

How have you identified that this spid is causing an issue?

Thanks I'll give it a go.

Thanks all. I thought as much but always nice to have it confirmed when it's your main db. I will take the file corruption into account and may change it...

Nice.

Anbody got any ideas?

You could try Activity Monitor, See which spid is using the most CPU/Memory

Use the dmv sys.sysprocesses

Script 1

Check Status of active transactions

SELECT

tat.transaction_id [TransactionID],

tat.transaction_begin_time [TranBeginTime],

CASE tat.transaction_type

WHEN 1 THEN 'Read/Write transaction'

WHEN 2...

Do I simply need to change SQL mode on MYSL