LOVER OF SQL (11/18/2011)
Dear, Thank you, but the memory is 50%, thus, may a good...
and about the deadlock, I think is difficult, just because the instance of database is not much accessed... and It's happened at midnight...
Which memory is 50% of what? Can you share specific numbers?
Does this job run anytime other than midnight? What else is running at midnight? Is there anything other than SQL Server installed on either machine?