InvestorsHub Logo
Boards
News
Market Data
Markets
Discover
Discover
AI Subscribe Login/Register account icon
S&P 500
5,978.77
(
0.84%
)
US TECH 100
20,533.20
(
1.53%
)
Dow Jones
43,779.40
(
0.11%
)
Brent Oil
75.41
(
0.45%
)
Bitcoin
76,637.35
(
1.31%
)
Post# of 1535
Next 10
Reply Private New
Public Reply Private Reply New Post
Keep Last Read
Keep Next 10 Report Keyboard Shortcuts
Next 10 Prev Next

Bob Zumbrunnen

Send PM Follow Ignore
Followers 211
Posts 7903
Boards Moderated 15
Alias Born 05/24/2001

Bob Zumbrunnen

Re: Bob Zumbrunnen post# 989

Tuesday, 03/15/2005 11:59:57 AM

Tuesday, March 15, 2005 11:59:57 AM

Post# of 1535
3 minutes, 50 seconds. Dammit!

I'm not finding any discussion anywhere on the subject, but am wondering if the fact that this search table's "Update Index in Background" is enabled, is overriding the sp_fulltext_service('resourceusage') setting. That setting was 4 and I bumped it up to 5 (highest level) but noticed MSDN lists a setting of "1" as being "Background".

The database server has enough horsepower that it should be able to make MSSearch its highest priority and still have more than enough resources left to do all the SQL stuff it has to do.
Public Reply Private Reply New Post
Keep Last Read
Keep Last Read Next 10 Report Keyboard Shortcuts
Next 10 Prev Next
Join InvestorsHub

Join the InvestorsHub Community

Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.

Sign Up