SQL Server Full Text Search resource consumption
- by Sam Saffron
When SQL Server builds a fulltext index computer resources are consumed (IO/Memory/CPU)
Similarly when you perform full text searches, resources are consumed.
How can I get a gauge over a 24 hour period of the exact amount of CPU and IO(reads/writes) that fulltext is responsible for, in relation to global SQL Server resource usage.
Are there any perfmon counters, DMVs or profiler traces I can use to help answer this question?