http://www.sqlservercentral.com/scripts/Miscellaneous/67422/
Use logparser to grab a specific event from a remote event log (and stuff it into a CSV file)
logparser -i:evt “select distinct Message INTO filename.csv from yourservernameApplication where Message Like ‘%http://yoursite.domain.com/Person.aspx?guid%’ ” -o:CSV
Result of enabling AWE on 8GB SQL Server
AWE enables SQL Server to use ram beyond 4GB in a 32-bit architecture. Here is the “before” and “after” states on a SQL Server with 8GB of RAM (where SQL Server was allocated 7GB). Note the 272MB available before AWE and the 6.79GB available AWE was enabled.
