FT:Crawl Started Event Class


Applies To: SQL Server 2016

The FT:Crawl Started event class indicates that a full-text crawl (population) has started. Use this event class to check if a crawl request is actually being picked up by worker tasks.

Data column nameData typeDescriptionColumn IDFilterable
DatabaseIDintID of the database in which the full-text crawl was started. Determine the value for a database by using the DB_ID function.3Yes
EventClassintType of event = 155.27No
EventSequenceintSequence of a given event within the request.51No
IsSystemintIndicates whether the event occurred on a system process or a user process. 1 = system, 0 = user.60Yes
ObjectIDintSystem-assigned ID of the object. The full-text crawl was started on the full-text index on this object.22Yes
SessionLoginNamenvarcharLogin name of the user who originated the session. For example, if you connect to SQL Server using Login1 and execute a statement as Login2, SessionLoginName shows Login1 and LoginName shows Login2. This column displays both SQL Server and Microsoft Windows logins.64Yes
SPIDintID of the session on which the event occurred.12Yes
StartTimedatetimeTime at which the event started, if available.14Yes
TextDatantextFull-text crawl type. The value can be Full, Incremental, Manual, or Auto.1Yes
TransactionIDbigintSystem-assigned ID of the transaction.4Yes

sp_trace_setevent (Transact-SQL)

Community Additions