Confusion in AWE

suppose i have enabled only AWE option in sql server but i didn't add 3

GB switch in boot.ini. in this case what will be the effect on physical memory?

Having /PAE in your boot.ini file allows a 32-bit OS to access more than 4GB ofRAM using AWE. Using /3GB in the boot.ini file only reserves 1GB for the OS, and allows applications to use 3GB of RAM instead of the normal 2GB of RAM.

http://support.microsoft.com/kb/274750

http://msdn2.microsoft.com/en-us/library/ms175581.aspx

|||

/PAE can you be used only for intel

In case other model what can be used to access more than 4GB of memory

|||

Hi Satyanarayana,

what platform is your sql machine. Also is it 32bit or 64 bit? And how much RAM is on the box.

Jag

|||we are using AMD opteron processor. it is 32 bit and about 4GB RAM|||

With only 4gb of RAM there is no need for /PAE. Using /3GB will allow for use of up to 3GB of Virtual address space by SQL Server. This will likely be sufficient for a machine with 4GB of RAM.

|||

AWE will be in effect with or without the /3GB switch. The AWE mechanism require the process using it to "map" the memory into a window in virtual memory. The size of this window will be greater (and therefore more RAM could be mapped simulataneously if the /3GB switch is used)

Thanks, Ron D.

|||today it is 4GB. tomorrow definitely physical memory will be increased (say 8 GB). in that case what can done for non intel machines to use more than 3GB of memory|||how do we know the AWE is in effect?|||

The following message should be in the errorlog:

"Address Windowing Extensions is enabled. This is an informational message only; no user action is required."

Thanks, Ron D.

Configuring SQL 2000 for use with ESRI ArcSDE

Rookie here....
I need help making some changes so that security is enabled on the ESRI
side. My problem is this. I have Two databases (SDE and Vector) 3 Roles
(Viewer, Editor 1 and Editor 2) and multiple users/logins. I can not find
any documentation which specifies how I assigne users to roles. In addition,
I can not find out which users in which databases should have Create Table,
Create Function Create SP, etc...
Any one have any good resources I can look at?
You can assign SQL Server users to database roles using sp_addrolemember:
USE SDE
EXEC sp_addrolemember 'Viewer', 'SomeUser'
GO
Permissions are entirely application specific. I assume these roles are
pre-defined by the app and appropriate object permissions assigned. Your
application documentation should specify if any additional permissions (e.g.
CREATE) are needed by application users. If the app doc doesn't contain
this information and you have security issues, I suggest to contact the
vendor for clarification of security requirements. You might get lucky with
a knowledgeable ESRI user in this forum but your vendor is the authoritative
source.
Hope this helps.
Dan Guzman
SQL Server MVP
"Joe16" <Joe16@.discussions.microsoft.com> wrote in message
news:D0F741EF-8DAA-4630-A6EA-49564330B345@.microsoft.com...
> Rookie here....
> I need help making some changes so that security is enabled on the ESRI
> side. My problem is this. I have Two databases (SDE and Vector) 3 Roles
> (Viewer, Editor 1 and Editor 2) and multiple users/logins. I can not find
> any documentation which specifies how I assigne users to roles. In
> addition,
> I can not find out which users in which databases should have Create
> Table,
> Create Function Create SP, etc...
> Any one have any good resources I can look at?
>