Poor Performance Health due to Spotlight queries. There are waits of Preemptive_OS

Chat now with support

Poor Performance Health due to Spotlight queries. There are waits of Preemptive_OS_Waitforsingleobject. (150950)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Poor Performance Health due to Spotlight queries. There are waits of Preemptive_OS_Waitforsingleobject.
Description

There is a Spotlight on SQL Server Enterprise statement with a wait of Preemptive_OS_Waitforsingleobject with a value of 1918 ms that appears to represent about 60% of the total waits.
Cause

This wait occurs because the SQL script is getting data from the OS about volume sizes.
Resolution

Issue fixed in the current release of Spotlight on SQL Server Enterprise. Latest version of Spotlight can be downloaded from here.
Defect ID

SOSSE-4223

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Poor Performance Health due to Spotlight queries. There are waits of Preemptive_OS_Waitforsingleobject. (150950)