Thank you , reading up on deciphering the wait resource helped me understand that.

So we know that there are two rows locked in the index based on the index...

What's the recovery model of the report server tempdb ?

That should point you in the right direction ....

In any case large or full log files are no reason to restart...

Thanks Jack and Gail

Thanks for your reply Jack , so that would mean that SQL Server would have to actually do a row lookup to return the value for the Orderno, and would...

Thanks for the reply

When you say easier to store with the VM, do you mean the same LUN that the .vmdk file is stored on

OR

Do you mean...

Thanks GilaMonster, makes sense to avoid future surprises.

Would be interesting to see the non clustered index column definition inclusive of the clustered index ... From my understanding the index would...

The cluster is based on windows server 2003 can I have a witness file share ? Also we have setup standard quorum since we have 2 nodes, this way we...

Thanks for your suggestions

Here is the directory listing

The Quorum drive has 1GB space assigned to it

Volume in drive Q is SQLRDM02-Quorum00

Volume Serial Number is

Directory of Q:

10/07/2013 08:11 PM...

@Dhananjay,

From Windows explorer the only directories I see are the MSCS and MSDTC, there is nothing else that I can see that could be steadily eating up the disk space...

Thanks for your reply Jeff, but Im unable to make the corelation between inefficient code and the quorum disk running low on disk space.

Would you be ableto elaborate on the...

Thanks for your reply, however the strange part is when I view the quorum disk through windows explorer, I cannot see what is filling up the disk. I could try...

Hey Sean ,

The issue is I have a 4 part naming here, so Im looking for a method to move from PROD - TEST and TEST - PROD without...

Thanks ...your answers are much appreciated

Thanks , it looked to be a SSMS session , works fine now