Does anybody have any further ideas?

Thank you to all who have assisted - It is much appreciated.

Hey Jeff,
I forgot to add; the monitoring software is simply an SQL product I developed that only runs queries against the database (that I have checked to ensure are not...

Hey Roger,
Thanks for the reply.
We currently don't have any specific backup software - we simply use Ola Hallengren's backup code. Also, we only carry out 15-minute interval transaction...

Hi Jeff,
Thank you for your reply and help again.

I will check for anti-virus software tomorrow. There might be something automatic that Amazon do, that we don't know about.

Hey Jeff,

Thank you very kindly for your reply.
We have some monitoring software that alerts us to deadlocks and long running queries (that are being blocked) and their...

Hi Gail,

Thank you very much for your informative reply. I unfortunately did not capture all of the query plan info from the last issue. I have just started work at...

Sorry, I forgot to mention, the table that I am deleting from has 161k of records in it, and the deletion is based on the primary key which should be...

Hi Everyone,

Btw Grant, I believe I have your 2nd edition book (it's awesome!).

A little more background into this issue:

1. The procedure runs every night. Oddly, 2/3 times a week it...

Hi Grant and everyone else assisting me,

Thank you for your analysis. I am sorry for not responding sooner; I have been in meetings about this issue all day.

I will attach...

Hi there,

Good call. I'll have a look into this. I will find out when table statistics are updated.

Does anyone have any further ideas?

Many thanks,

Laurence

Thanks for the reply.

I know you can obtain the file path from looking at the tab. I want to be able to obtain the file path using TSQL within the...

I really appreciate your help on this matter.

This is great; so I can setup a merge replication between clients and one SQL replication server, and then setup a transaction or...

Thank you for your advice TheSQLGuru.

I have to agree with you (about Enterprise too). That said, I should have told the whole story. We do have a group of professionals...

Thank you for your help too (GrumpyOldDBA).

We will indeed be using x64. We intend to have around 64GB of memory in our server. Do you think this would be adequate?

As...

I really appreciate your help here (sturner). This is a very sensible approach to this problem. I will contact the SAN manufacturer as you suggested.

I believe that currently we have...