Another fts question - after page faults

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
I would give Search 1/2 Gig, I would not use the priority boost. I have some
optimal settings for you to use which I will post as soon as I find them.
How many catalogs do you have? This is actually more important than the
number of indexes.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"CR" <me@.work.com> wrote in message
news:u1yNTAxOHHA.324@.TK2MSFTNGP06.phx.gbl...
> 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
>
|||We have 4 catalogs, and will be adding 6 more.
Thanks.
CR
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:Oru5lSxOHHA.4372@.TK2MSFTNGP04.phx.gbl...
>I would give Search 1/2 Gig, I would not use the priority boost. I have
>some optimal settings for you to use which I will post as soon as I find
>them.
> How many catalogs do you have? This is actually more important than the
> number of indexes.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "CR" <me@.work.com> wrote in message
> news:u1yNTAxOHHA.324@.TK2MSFTNGP06.phx.gbl...
>
|||Ideally each large table should have its own catalog.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"CR" <me@.work.com> wrote in message
news:eTJr$VxOHHA.320@.TK2MSFTNGP06.phx.gbl...
> We have 4 catalogs, and will be adding 6 more.
> Thanks.
> CR
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:Oru5lSxOHHA.4372@.TK2MSFTNGP04.phx.gbl...
>