We have noticed that a template field search to return only files results in the CPU on the SQL server spiking up to 90+% during the duration of the search and then dropping to almost 0 once the search is complete. Is this a normal/typical behavior?

This is in a Test Environment with the followings specs:

Laserfiche Server 9.2.1

Both Laserfiche Server And SQL server VMs are running Server 2012 R2 with 32GB RAM each. They are on different machines. The database size is about 125 GB and has already being re-indexed and statistics update.