Re: Batch Size
- From: "John Kane" <jt-kane@xxxxxxxxxxx>
- Date: Thu, 27 Oct 2005 22:45:25 -0700
Robert,
Not to worry, the private "SQL Server 2005" newsgroup has been taken down as
SQL Server 2005 RTM'ed today (10/27/05), so now this fulltext newsgroup is
officially both SQL Server 2000 FTS and SQL Server 2005 FTS (SQL2005FTS),
checkout my blog entry from today for some of the initial details: "SQL
Server 2005 has RTM'ed !!"
http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!552.entry
You're reading the SQL 2005 BOL title "Performance Tuning and Optimization
(Full-Text Search)"
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/fulltxt9/html/ef39ef1f-f0b7-4582-8e9c-31d4bd0ad35d.htm
Can I assume that you have already done the following?
1. Ensure the base table has a clustered index.
2. Place SQL [database] log (*.ldf), database files (*.mdf & *.ndf), and the
full-text catalog on separate disks.
Have you reviewed the MSFTESQL<$Instance_Name>:Service "Batches in ready
queue" perfmon counter values? I'm not sure what constitutes "low" for your
server, but could you reply back with the range of values you are seeing now
while the FT Indexing is ongoing?
FYI, the explain for this performance counter: "Number of batches in the
ready queue. This queue buffers work that will be given to the filter
daemons."
Thanks,
John
--
SQL 2005 Full Text Search
http://spaces.msn.com/members/jtkane/
"Robert G." <RobertG@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E854B496-382F-494F-B198-2F283E83D907@xxxxxxxxxxxxxxxx
> Adding to my post. I thought this was a 2005 specific newsgroup - sorry.
>
> I'm running sql2005 Sept. CTP Standard Edition. on a 4 way box with
> hyperthreading. fast XEON procesors (don't exactly remember how fast).
>
> Table is 4000000 rows and growing, and taking a LONG time (8 hours) to
> populate. I've done the other hardware things suggested by books online.
>
> Thanks.
>
> "Robert G." wrote:
>
>> Hi
>>
>> I'm trying to improve a crawl's performance. Online books refers to
>> changing the default batch size from 1600 to a number associated with the
>> number of processors on my server.
>>
>> For the life of me, I have no idea how to go about changing the batch
>> size
>> for full-text search. Any and all pointers apprciated.
>>
>> Rob
.
- Follow-Ups:
- Re: Batch Size
- From: Robert G.
- Re: Batch Size
- Prev by Date: Re: Batch Size
- Next by Date: Re: 'update index in background' not running.
- Previous by thread: Re: Batch Size
- Next by thread: Re: Batch Size
- Index(es):
Relevant Pages
|
|
