What is the -E switch in SQL Server?
(not -e but -E)
I have read this:
SQL Server can allocate 4 extents instead of 1 extent when the -E switch is
specified during startup. Hence, the -E switch enables SQL Server to issue
256 KB I/O even if extent fragmentation exists because of proportional fill.
Does this switch can improve the performance of a data warehouse database?
Re: Configuring SQL 2005 Memory ... I'm also trying to limit allocation of ram to SQL. ... I guess that I'm struggling with whether SQL (without this switch) limits itself to less than 2GB in aggregate of ram or does each instance stand on its own. ... Exchange isn't the only major application on SBS -- SQL Server is also running and my question was related to SQL and the 3/GB switch. ... The Address Windowing Extensions API that Microsoft Windows exposes allows application developers to access more than 2 GB of memory on 32-bit systems. ... (microsoft.public.windows.server.sbs)
Re: Configuring SQL 2005 Memory ... I guess that I'm struggling with whether SQL (without this switch) limits itself to less than 2GB in aggregate of ram or does each instance stand on its own. ... Exchange isn't the only major application on SBS -- SQL Server is also running and my question was related to SQL and the 3/GB switch. ... The Address Windowing Extensions API that Microsoft Windows exposes allows application developers to access more than 2 GB of memory on 32-bit systems. ... (microsoft.public.windows.server.sbs)
Re: Configuring SQL 2005 Memory ... Exchange isn't the only major application on SBS -- SQL Server is also running and my question was related to SQL and the 3/GB switch.... The Address Windowing Extensions API that Microsoft Windows exposes allows application developers to access more than 2 GB of memory on 32-bit systems. ... (microsoft.public.windows.server.sbs)
Re: Full Text - Index Population - HDD Access ... Have you implemented the /3GB switch in the OS boot.ini? ... 2GB is set aside for apps and 2GB for OS. ... This probably explains why SQL Server is only ... using 1.7GB RAM.... (microsoft.public.sqlserver.fulltext)
Re: Question RE /PAE In Active-Active Cluster ... different NT kernel which contains the code to address RAM> 4GB. ... The AWE setting in SQL Server works with the /PAE switch.... address by setting the max server memory config option.... (microsoft.public.sqlserver.clustering)
