Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2010-10-11 : 05:15:37
|
| Dear All,One of my senior left DBA has enabled AWE /3GB switch on the server to utilize more memory for SQL server. But becous of that we are not able to copy the file more than 40GB.Then we got the support from MS saying this.1. The direct cause to the failure is the paged pool exhaustion. When copying large files, both the client and the server will use a large amount of paged pool. When the pool is exhausted, you will experience that error.2. You have /3GB switch added in boot.ini, which assign 3GB memory space for user mode and only 1GB for kernel. That further squeezes out the kernel memory size. Please refer to the following resolution:1. Don’t use /3GB any more. Instead, to let SQL utilize the memory space higher than 4GB, use AWE instead. I see that you’ve added /PAE switch on the SQL server already. To enable AWE in SQL, please refer to this KB article:http://support.microsoft.com/kb/274750/en-usI am not sure what is my old DBA enabled and what now i need to do ?Can somebody expert here advice me.Thanks,Gangadhar |
|
|
pphillips001
Starting Member
23 Posts |
Posted - 2010-10-13 : 05:07:20
|
| From Management Studio, if you right-click server, properties, memory - there is a 'Use AWE to allocate memory' tick box.===========================There is no reality - only perspective. |
 |
|
|
|
|
|
AWE enable on server