• You can check the ring buffers for one of three different error messages, Out of Memory messages, Low Physical memory or Low Virtual memory. You can also use the DBCC MEMORY_STATUS to compare target committed to current committed. I go over all these with example scripts in this Simple-Talk article[/url]. Just run these scripts from PowerShell if that's what you need.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning