Another fts question - after page faults
- From: "CR" <me@xxxxxxxx>
- Date: Thu, 18 Jan 2007 08:51:01 -0600
Sorry for the repost, but this really should have been the start of a new
thread.
Ok, that brings up another question, our server is set to boost SQL Server
priority, would this slow down msftesql? We are running 4 3.2 Xeon's with 8
GB RAM (Maxmem is set to 7168 MB). We have 14 fulltext indexes with
approximately a million rows each, but within the next month we will be
adding 12 more fulltext indexes which, I believe, will be slightly larger,
and doubling our db size (currently we have 63 tables, the largest being 10
million rows, and total used mdf size is 17 GB). Do you think the boost SQL
Server setting will be slowing fulltext indexing? Or does this setting also
boost the priority of msftesql? Do you think the max memory setting above is
giving msftesql the room it needs?
Thanks.
CR
.
- Follow-Ups:
- Re: Another fts question - after page faults
- From: Hilary Cotter
- Re: Another fts question - after page faults
- Prev by Date: Re: page faults
- Next by Date: Re: Another fts question - after page faults
- Previous by thread: page faults
- Next by thread: Re: Another fts question - after page faults
- Index(es):
Relevant Pages
|
