page faults

From: "CR" <me@xxxxxxxx>
Date: Thu, 18 Jan 2007 07:05:41 -0600

Our performance is currently fine, but we are planning on adding more full
text indexes, so I have question.
Our database server is experiencing between 2,000 and 10,000 page faults
per second on msftesql.exe, as shown in task manager on the processes tab,
is this normal for a relatively busy website (50
million hits daily) with full text?

.

Follow-Ups:
- Re: page faults
  - From: Hilary Cotter

Prev by Date: Re: Fulltext Search or Like Search
Next by Date: Re: Fulltext Search or Like Search
Previous by thread: good, thorough documentation on full text issues?
Next by thread: Re: page faults
Index(es):
- Date
- Thread

Relevant Pages

Re: Company Web Stopped Working
... Because you are experiencing something nobody of us has experienced before. ... > the event log is below and that has been a few reboots ago. ... Check the database connection information and make ... > sure that the database server is running. ...
(microsoft.public.windows.server.sbs)
Re: Company Web Stopped Working
... Because you are experiencing something nobody of us has experienced before. ... I suggest you call MS PSS. ... Check the database connection information and make ... > sure that the database server is running. ...
(microsoft.public.windows.server.sbs)
AntiVirus Software on SQL Server
... I was taught that running Anti-virus software on a database server ... My network admin is planning a Windows 2000 ...
(microsoft.public.sqlserver.security)