Memory Stress Test in SQL Server 2005

I have a Windows 2003 Server running SQL 2005. The server has 32 GB of memory and I have enabled AWE in SQL. I have also configured the min and max SQL memory as 1 GB and 28 GB, respectively. However, this server currently has very low activity so I'm not sure whether my AWE-related changes worked. SQLSERVR.EXE process takes up about 100 MB of memory. Is there any tool or scripts that I can use to memory stress SQL to confirm that AWE is really in effect ?

The are several ways. The easiest is to check the errrolog and look for a message like "Address Windowing Extensions is enabled. This is an informational message only; no user action is required.". This entry in MSDN is also relevant: http://msdn2.microsoft.com/en-us/library/ms190673.aspx

The following links may help you understand SQL Server memory usage:

http://msdn2.microsoft.com/en-us/library/ms176018.aspx (SQL Server 2005 monitoring memory usage)

http://support.microsoft.com/kb/907877 (DBCC memorystatus)

http://blogs.msdn.com/slavao/archive/tags/SQL+Server+Memory+Management/default.aspx (Slava's blog)

Thanks, Ron D.