A little update which seems to underline one of Kevins first statements: network is especially important here.

A VMware specialist has reviewed the environment and did come up with a few...

Oh, this will so much be a great learning experience..

@kevin, hopefully your jet-lag will quickly fade... I very much care about those details. The current SQL 2012 is...

Thanks for the feedback.

Regarding the index and statistics maintenance; that is done on a weekly basis using Ola Hallengrens solution. But even with a refreshed set of indices and up...

Setting the 'min memory per query (KB)' to a higher value could also be considered (after thorough research) as an option to prevent spilling to tempdb.

You only need to set up the Event Notification for the database (or server). The stored procedure is only needed in the database where the queue resides. You could send...

If you need a jump start on working with Relog.exe to get .blg files into SQL Server, check out those two links.

Relog SQL database schema (nasty datetime handling)

Relog Syntax Examples...

Laurie Bantin (7/16/2008)

---

Have you read this article?

http://msdn.microsoft.com/en-us/library/ms345137.aspx

i think you can write the query in the new syntax much more clearly and easily (if you are using SQL Server...