Re: FTS query performance on SQL 2005

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hilary,
Here is the result of that query:
name=max server memory (MB)
minimum=16
maximum=2147483647
config_value=4096
run_value=4096
Is that configured correctly for a server w/ 2GB of physical RAM?

Also, in one of your earlier posts, you mentioned setting "max full-text
crawl range" to the number of CPU's on the system. I have a dual-core Xeon
processor, meaning it has 2 CPU's (in one chip). However, due to Hyper
Threading, Windows and SQL Server see this server as having 4 CPU's, so I
have that value set to 4. Is that a good setting?

All of my tests have been on just the single table that contains my
full-text index, such as "select ItemID from Item where
contains(ItemText,'"George Bush"')", so there are no other tables involved.

Thanks for all of your insightful replies.


.

Relevant Pages

  • Re: Configure memory usage
    ... sp_configure 'max server memory', 6144 ... Now my server is windows enterprise 2003 Enterprise 64-bit (12 GB of ... physical RAM). ...
    (microsoft.public.sqlserver.setup)
  • Re: charter
    ... > also mentioned setting up a *server* and people thought you going to ... possibly private *group* and got worried. ... Prev by Date: ...
    (uk.rec.sheds)
  • Re: SBS 2008 becomes slow a few days after restart
    ... I don't see a mention of the actual physical RAM installed? ... "Amos Sobel" wrote: ... My server consist of a SuperMicro mainboard using 2x 2Ghz Dual Opteron, ... My server is running Exchange 2007 and Symantec BE 12.5 which has it's ...
    (microsoft.public.windows.server.sbs)
  • RE: Memory configuration for Win2k3 and SQL2k
    ... > Max server memory should be set to the max memory you want to dedicate to SQL Server. ... > To prevent page file fragmentation, it is recommended that you set the paging file size initial and maximum values to be the same value. ...
    (microsoft.public.sqlserver.clustering)
  • RE: Memory configuration for Win2k3 and SQL2k
    ... Max server memory should be set to the max memory you want to dedicate to SQL Server. ... it is recommended that you set the paging file size initial and maximum values to be the same value. ...
    (microsoft.public.sqlserver.clustering)