SpotLight

    • 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
      • 332 views
      • 0 Likes
      • 4 replies
    • 02 May 2018 at 04:51 PM
    • Last post by jonathan nilsson on 04 Jun 2018 at 11:08 AM
    • 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
      • 724 views
      • 0 Likes
      • 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
      • 721 views
      • 0 Likes
      • 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
      • 1889 views
      • 0 Likes
      • 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
      • 1779 views
      • 0 Likes
      • 1 reply
    • 07 Nov 2017 at 05:01 PM
    • Last post by Gita Sharifi on 09 Nov 2017 at 06:00 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
      • 1986 views
      • 0 Likes
      • 3 replies
    • 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
      • 1943 views
      • 0 Likes
      • 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
      • 2809 views
      • 1 Like
      • 4 replies
    • 18 Sep 2017 at 11:28 AM
    • Last post by Gita Sharifi on 25 Sep 2017 at 03:40 PM
    • Grouping objects in Spotlight V12 0

      I've just upgraded to Spotlight V12 and noticed that the 'Enterprise Views' have been removed.
      Is there any chance of reinstating this as it was a very useful feature that enabled us to group various objects together by application so that...

      • SpotLight
      • 2590 views
      • 0 Likes
      • 4 replies
    • 08 Sep 2017 at 10:43 AM
    • Last post by kevin.page on 19 Sep 2017 at 09:27 AM
    • Spotlight mobile information security 0

      Hi,

      I am looking at deploying Spotlight mobile so that I can monitor the environment on the go.

      However, I work for a hospital and need to make sure that no patient information is sent outside of the organisation.

      Could you confirm if there are any query...

      • SpotLight
      • 2847 views
      • 0 Likes
      • 5 replies
    • 13 Sep 2017 at 04:56 PM
    • Last post by vmascari on 18 Sep 2017 at 05:14 PM
    • "invalid" Wait Time Type 0

      Under Wait Events, I see a 60,000ms Wait Time that comes and goes - but, sometimes will sit there for hours and also disappear for days.

      It is for a Wait Type of "invalid". I cannot seem to find what an "invalid" Wait Time is.  It is...

      • SpotLight
      • 2193 views
      • 0 Likes
      • 2 replies