• State Verified Answer
  • Replies 2 replies
  • Subscribers 7 subscribers
  • Views 2213 views
  • Users 0 members are here
Options
Related

Spotlight causing performance issues?

paul.bankston
over 2 years ago

One of out SQL Servers was having performance and the application team claims it was Spotlight causing the issue.  I am attempting to determine if this is true and was wondering if there is any information available related to this?

Thanks,

  • 0 over 2 years ago

    Hi Paul,

    You might want to try using Spotlight to monitor its own activity to determine the amount of workload or waits on the instance. You can use the Workload Analysis and Wait Event dashboards to isolate Spotlight’s load on the instance. Make sure the Connections Properties | Advanced Options | Exclude Spotlight from Wait Events and Workload Analysis option is disabled. Then use the dashboard’s workload dimensional tree to hone down on Spotlight transactions and amount of workload and events they’re imposing on the instance. Leverage the time frame selector to analyze the activity over time.

    Hope that helps out.

    Gita
    Spotlight Support