• 07 Nov 2017 at 05:01 PM
    • Last post by Gita Sharifi on 14 Sep 2018 at 03:26 PM
    • Change to SQL User

      0

      The diagnostic Server was installed with a SQL login, not a Windows one. 

      That SQL now login has to have its password updated.

      How do I update the Diagnostic Server with the new password?

      Do I have to fully re-install it?

      Thanks

      Jo

      • SpotLight
      • 3097 views
      • 5 replies
    • 04 Sep 2018 at 08:51 AM
    • Last post by Gita Sharifi on 07 Sep 2018 at 06:40 PM
    • Spotlight Playback Playback error [Connection Error]

      0

      Hi,

      I have installed the diagnostic server - spotlight playback on the same server as the database and the Spotlight installation. I am receiving the below error:


      High Diagnostic Server - Spotlight Playback Playback error [Connection Error]: Connecting...

      • SpotLight
      • 466 views
      • 3 replies
    • 02 May 2018 at 04:51 PM
    • Last post by Gita Sharifi on 31 Aug 2018 at 12:45 PM
    • Availability Groups and backup alarms

      0

      I have read through some of the discussions of how to handle alarms for database backups with Availability Groups but still have not solved my issue.  I do backups from the Primary replica in the Availability Group.  When my AG fails over, I get alarms...

      • SpotLight
      • 2080 views
      • 9 replies
    • 30 May 2018 at 04:00 PM
    • Last post by jim.drewe on 05 Jun 2018 at 05:01 PM
    • Query Execution Statistics

      0

      Hi.  I have a question about Query Execution Statistics in Spotlight on SQL Server Enterprise, version 12.1.0.   What I am wondering about is how far back does the "last 50" statistics go?  That is, is it four hours, 24 hours. or forever?  I don...

      • SpotLight
      • 1542 views
      • 4 replies
    • 23 Apr 2018 at 03:54 PM
    • Last post by Gita Sharifi on 24 Apr 2018 at 04:39 PM
    • Alarms for specific Service installed on the Database server

      0

      Hi,

       

      I have a service called TunnelSetup running in my database server. Can I set an alarm for that specific service using Spotlight? 

      I want to spotlight's alarm to send us an email when that windows service stops running.

       

      What i have so far?

      How...

      • SpotLight
      • 1653 views
      • 3 replies
    • 22 Nov 2017 at 09:24 AM
    • Last post by Gita Sharifi on 23 Nov 2017 at 03:52 PM
    • Spotlight licensing with federation

      0

      Hi,
      I currently have one diagnostic server monitoring one server room and 2 seat-based licenses for myself plus one other to use the client console.
      I'm investigating what would be required to expand this to cover multiple computer rooms and am looking...

      • SpotLight
      • 2639 views
      • 1 reply
    • 13 Nov 2017 at 10:52 PM
    • Last post by Gita Sharifi on 14 Nov 2017 at 03:43 PM
    • Spotlight - Support TLS v1.2

      0

      Does Spotlight support TLS v1.2 connections to SQL Server?   Are there specifics that should be known about configuring the Diagnostic servers?

      In the scenario that TLS v1 and v1.1 have been disabled on your monitored server(s). 

       

       

       

      Alarm: Monitored Server...

      • SpotLight
      • 2694 views
      • 1 reply
    • 06 Nov 2017 at 11:42 PM
    • Last post by Gita Sharifi on 08 Nov 2017 at 01:32 PM
    • Port number for Spotlight client

      0

      I am trying to figure out which port number I need to use for letting a Spotlight client (not the server being monitored, but the server from where the Spotlight console can be accessed) communicate with the Spotlight diagnostic server.

       

      I see the below...

      • SpotLight
      • 2931 views
      • 3 replies
    • 03 Oct 2017 at 02:59 PM
    • Last post by Gita Sharifi on 04 Oct 2017 at 04:23 PM
    • Deadlock SQL trace

      0

      Hello,

      We have a lots of session running under spotlight deadlock trace and consume good amount of CPU. I have set the deadlock list setting to off from Spotlight->Configure->Scheduling->Deadlock List. But, it seems like the trace is still running. How...

      • SpotLight
      • 4011 views
      • 4 replies