"ISTS" wrote:

> Hi
>
> We are running full text search with 4GB RAM on SQL server 2000. Ihave the
> /3G option on in boot.ini. The VM setting is set at 2048 to 4095.
>
> I read it in the manual that the optimal configuration for full text search
> is
>
> 1. The virtual memory size to at least 3 times the physical memory installed
> in the computer.
> 2. The SQL Server max server memory server configuration option to 1.5 times
> the physical memory (half the virtual memory size setting).
>
> Questions:
> 1. How do I set max sql server memory to 1.5 times physical memory? Max
> memory that SQL server allows us to set is 4095 MB? Is this only possible
> with AWE?
>
> 2. My observation when I made the VM 3X the physical, was that the full text
> queries were slower.
>
> What are the right settings and what am I doing wrong?
>
> --