• I would suggest focusing first on wait stats to understand what is causing the server to run slow. But, if you want to know if you're out of memory, going after messages in the system through the ring buffers is the best way. You can run queries against sys.dm_os_ring_buffers to determine if you're getting out of memory messages. I wrote about it in an article on SimpleTalk[/url].

    "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