Full text search is a Windows service that can optionally be installed with SQL Server. This service, which is also called MSSearch service, allows indexing of selected columns in a way that allows users to search any word, phrase, or derivative of any word contained in that column.
This wait event occurs when the session needs a free buffer, so it can bring a data block into the buffer cache, and is waiting for a buffer that is not dirty to become available. This can occur if DBWR is not writing dirty buffers to disk fast enough.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité