Re: FTS query performance on SQL 2005

Hello Simon,
This is a new SQL install. I just created the table, loaded it with all 20
million rows from a text file via "Import data...", then created the
full-text index (which took about 2 hours). My table basically includes an
"int" primary key (clustered index) column and a "text" column with the text
to be indexed. The table also includes 2 other "text" fields, but they're
not involved in these queries. The result is a database .MDF file of approx.
12GB and a full-text index with files of approx. 2GB, with the full-text
index containing approx. 1.4 million unique keys.

When I look at task manager for memory usage, I see the following:
sqlservr.exe --> mem usage=740MB, VM size=749MB
msftesql.exe --> mem usage=7.6MB, VM size=5MB
Right after a reboot, these numbers are continually rising, but after a
number of queries, these numbers steady out to the ones listed above. Based
on this, would you recommend that I change my memory configuration?

Thanks.


.

Relevant Pages

  • Re: Indexing strategy
    ... This table has approx 25 million rows. ... Quite often queries would be needed for everything ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Perl hashing speedup ?
    ... million entries. ... In case you need any additional information about memory usage, ... Memory used by process - 26 MB (Approx) ... than a Perl native hash, but if it prevents you from hitting the disk, ...
    (comp.lang.perl.moderated)
  • OutOfMemoryException: Webservice, DataSet and file transport
    ... For transportation of a file, approx 850kB, I use a webservice which return ... The memory usage ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Issues With Exchange 5.5
    ... Grows in size, or in memory usage? ... Exchange will use as much memory as it ... > The backup went through fine. ... I estimate that it has grown approx ...
    (microsoft.public.win2000.general)
  • Re: 32bit vs. 64bit memory usage
    ... Thanks Simon. ... 32bit vs. 64bit memory usage ... We encountered some problems with Oracle 9i. ... If we switch back to 32bit, and bring the app up, We have approx. ...
    (AIX-L)