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

 

Filed under SQL Server

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

%d bloggers like this: