| How to
monitor memory usage? |
|
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
|
 |
| The Best SQL Server
2005 Training in the World |
|