Spotlight is causing a client server to experience very low page life expectancy.
The code causing this is in "QS_FragmentationOverview.sql".
There is a known issue in SoSSE 10.5.0 that means the Fragmentation Overview query runs every-time one navigates to the home page.
In some environments, this query can be very expensive.
RESOLUTION
Upgrade to the Spotlight on SQL Server Enterprise 10.5.1.
STATUS
Issue fixed in version 10.5.1. The latest version of Spotlight on SQL Server Enterprise can be downloaded at: Spotlight on SQL Server Enterprise latest version
