SQL Server Profiler – “Not enough memory was available for trace”
13-Jan-1010 Leave a comment
Need to enable AWE on SQL Server which is an element of memory
Before doing this need to follow
"How to: Enable the Lock Pages in Memory Option (Windows)"
Then "Enabling AWE Memory for SQL Server"
The following is copied from there:
—————————————–
"Example
The following example shows how to activate AWE and configure a limit of 1
GB for min server memory and 6
GB for max server memory.
First, configure AWE:
Copy Code
sp_configure 'show advanced options', 1 RECONFIGURE GO sp_configure 'awe enabled', 1 RECONFIGURE GO
After SQL Server restarts, the following message is written to the SQL Server error log: "Address Windowing Extensions enabled."
Next, configure memory:
Copy Code
sp_configure 'min server memory', 1024 RECONFIGURE GO sp_configure 'max server memory', 6144 RECONFIGURE GO