Execute the following script in Query Editor to monitor memory usage. The command provides a snapshot of the current memory status of SQL Server 2005. The output from this command is useful in troubleshooting issues that relate to the memory consumption of SQL Server or to specific out-of-memory errors. To redirect the output for analysis run it from SQLCMD and save the output into a flatfile.

use AdventureWorks
go

dbcc memorystatus
go