Hi <customer name>,
Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.
From your description, I understand that you recieve the following error
message and would like me to help to fix it. Is it correct? If I have
misunderstood, please let me know.
"query was unable to run due to insufficient memory"
Based on the current information, the issue seems to be a permance issue;
it might be a bit complex and take us long time to fix it.
To let the SQL Server use more monery, we need to do the following.
A if the SQL Server is 64-bit, the SQL Server will use as much momery as it
can
B if the SQL Server is 32-bit, by default, it use 2 GB. To use more memory,
we need to do the follinng.
1 Enable /PAE Switch in Boot.ini for SQL Servers with RAM > 4GB
Verify the /PAE switch is in the boot.ini file for all servers with
physical RAM > 4GB (reboot is required).
Sample boot.ini:
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(2)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Windows Server 2003,
Enterprise" /fastdetect /PAE
Note: /3GB and /PAE switches should NOT be used together on SQL servers
The purpose of this step is to make the Window Server use more than 4 GB
memory on 32-bit product.
2. sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
The goal of this step is to have the AWE switch on for SQL Server.
3. sp_configure 'min server memory', x(x means that the number you want to
set )
RECONFIGURE
GO
sp_configure 'max server memory', y(y means that the number you want
to set )
RECONFIGURE
GO
The goal of this step is to configure the memory you want the SQL to
use.
I believe that after you take these steps correctly, the SQL Server will
use more than 4 GB.
You can run the script below and look for min server memory and max server
memory to make sure.
select *
from sys.configurations
If the error still happens after taking the above, we need more information
to diagnosis the issue. So please send me a email. My email address is
v-fathan.TakeThisOut@online.microsoft.com(remove online) and then I will create a
workspace for you to upload the required files
If there is anything unclear, please o let me know.
Best regards,
Mark Han
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg.TakeThisOut@microsoft.com.
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 business day is acceptable. Please
note that each follow up response may take approximately
2 business days as the support professional working with you may need
further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are
best handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
FAQ
Search
Profile
Private Messages
Log in
