Having issue with the sql server 2008 default trace interferring with spotlight (4368544)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Having issue with the sql server 2008 default trace interferring with spotlight
Description

Having issue with the sql server 2008 default trace interferring with spotlight diagnostic server. The Spotlight seems to be affecting performance on the monitored instance.
Cause

SQL Analysis was configured to run continuous row set trace indefinitely
Resolution

Disable SQL Analysis continuous row set trace as this can impact performance per the product documentation (see Help file)

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title