Spotlight on SQL Server Forum - Toad for SQL Server - Toad World
Gita Sharifi
Follow / 13 Jan 2017 at 5:34pm / Toad for SQL Server

What’s new for Spotlight on SQL Server Enterprise – January 2017

Expand content
This monthly publication will provide new and updated information regarding the products that we offer and organized in the following categories: Documentation, Product Notifications, Knowledge Base Articles...

This monthly publication will provide new and updated information regarding the products that we offer and organized in the following categories: Documentation, Product Notifications, Knowledge Base Articles, Product Life Cycle and Training Videos.

New enhancements and fixes of Spotlight 11.7.1 patch release.
https://support.quest.com/spotlight-on-sql-server-enterprise/kb/223943/?cmpid=soc:spotlight-line:communties:01



112 0 / Create an account to join the discussion.
Gita Sharifi
Follow / 15 Nov 2016 at 9:53pm / Toad for SQL Server

What’s new for Spotlight on SQL Server Enterprise – November 2016

Expand content
This monthly publication will provide new and updated information regarding the products that we offer and organized in the following categories: Documentation, Product Notifications, Knowledge Base Articles...

This monthly publication will provide new and updated information regarding the products that we offer and organized in the following categories: Documentation, Product Notifications, Knowledge Base Articles, Product Life Cycle and Training Videos.

New Knowledge Base Articles

https://support.software.dell.com/spotlight-on-sql-server-enterprise/kb/214812


New enhancements and fixes of Spotlight 11.7 patch release.

285 0 / Create an account to join the discussion.
Danny Torres
Follow / 1 Nov 2016 at 1:58pm / Toad for SQL Server

We are now on Twitter!!! Contact a Technical Support expert today...

Expand content
Do you have a quick support question and short of time? Contact us Via Twitter @ QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

Do you have a quick support question and short of time? Contact us Via Twitter  @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

384 0 / Create an account to join the discussion.
Gita Sharifi
Follow / 1 Nov 2016 at 12:57pm / Toad for SQL Server

We are now on Twitter!!! Contact a Technical Support expert today...

Expand content
Do you have a quick support question and short of time ? Contact us via Twitter @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

Do you have a quick support question and short of time ? Contact us via Twitter @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

 

360 0 / Create an account to join the discussion.
Gita Sharifi
Follow / 9 Sep 2016 at 2:47pm / Toad for SQL Server

Spotlight on SQL Server Enterprise - How to get the most out of this...

Expand content
The better a problem is described, the better the assistance tends to be. In order to better assist with your issue at hand, please include the following information in your initial post: - Product...

The better a problem is described, the better the assistance tends to be.

In order to better assist with your issue at hand, please include the following information in your initial post:

- Product version and relevant environment details such as server and database versions and builds.
- Include a screenshot of the problem or error.
- Describe the problem fully. What result was expected?
- Can the issue be created on demand or is it intermittent? Provide exact steps to recreate the problem if possible.
- Generate a support bundle file if necessary. In Spotlight, select Help | Support Bundle option to generate support bundle zip file.

*Note: Please refrain from including private data in your posts

Be as thorough as you can with the provided info. We will reply to you as quick as possible. We are glad to assist you.

832 0 / Create an account to join the discussion.
Gita Sharifi
Follow / 9 Sep 2016 at 2:33pm / Toad for SQL Server

Latest Release Information

Expand content
Here you can find information on our latest release, from features to downloads & documentation. - New features from our Release Notes documentation: https://support.software.dell.com/spotlight-on...

Here you can find information on our latest release, from features to downloads & documentation.

- New features from our Release Notes documentation:
https://support.software.dell.com/spotlight-on-sql-server-enterprise/release-notes-guides

 - Link to download the latest version of Spotlight:
https://support.software.dell.com/spotlight-on-sql-server-enterprise/download-new-releases

 - Link to Trial edition of Spotlight:
https://software.dell.com/products/spotlight-on-sql-server-enterprise/

1158 0 / Create an account to join the discussion.
Gita Sharifi
Follow / 8 Sep 2016 at 8:54pm / Toad for SQL Server

Top 5 Knowledge Base Articles

Expand content
Here you can find what knowledge articles are trending. These are this month’s Top Knowledge Base Articles: 1. What is new in Spotlight on SQL Server Enterprise 11.6.1? https://support.software...

Here you can find what knowledge articles are trending. These are this month’s Top Knowledge Base Articles:

1.  What is new in Spotlight on SQL Server Enterprise 11.6.1?
https://support.software.dell.com/spotlight-on-sql-server-enterprise/kb/198539


2. VIDEO - How to Install Spotlight on SQL Server Enterprise.
https://support.software.dell.com/spotlight-on-sql-server-enterprise/kb/177236


3. What is Spotlight federation?
https://support.software.dell.com/spotlight-on-sql-server-enterprise/kb/199397


4. Error during connect: "Error 800706BA: The RPC server is unavailable"
https://support.software.dell.com/spotlight-on-sql-server-enterprise/kb/56100


5. Error: "Access is denied (Exception from HRESULT: 0x8007005 (E_ACCESSDENIED)"
https://support.software.dell.com/spotlight-on-sql-server-enterprise/kb/84287

 
Feel free to browse them. Remember to sign in to get the entire information available for our Register users.

885 0 / Create an account to join the discussion.
Ken.Hemmerling
Follow / 30 Jan 2017 at 8:51pm / Toad for SQL Server
Latest post by on 31 Jan 2017 at 1:59pm

CPU information for the OS cannot be collected. Windows connection...

Expand content
Hello, I have a SQL availability group named SharePoint-AG running in an active/passive manner on two servers: SRV6 and SRV7. I have added SharePoint-AG as a SQL Server to Spotlight running on the cluster...

Hello,

I have a SQL availability group named SharePoint-AG running in an active/passive manner on two servers:  SRV6 and SRV7.  I have added SharePoint-AG as a SQL Server to Spotlight running on the cluster SharePoint-AG.  (Yes, the SQL listener and the cluster have the exact same name - don't judge me too harshly as this was my first availability group.)  When I go into the SQL server SharePoint-AG properties, the connection is set to SharePoint-AG as "Cluster (monitor active node).  When I click the Test button, Spotlight reports "SQL Server Test Successded".  I've also added an Availability Group connection for SharePoint-AG showing that it runs on SRV6 and SRV7.  Again, when I click on the Test button for the Availability Group, I get "Availability Group Test Succeeded".  I've also added SRV6 and SRV7 as Windows servers.

When I select Windows SRV6 or Windows SRV7, I see the CPU load on each server but when I select SQL Server SharePoint-AG, the CPU Usage monitor is greyed out and had an error flag that reads "CPU information for the OS cannot be collected.  Windows connection details have not been set up."

Can anyone confirm if the CPU Usage monitor works with SQL running as an Availability Group?  Does anyone have any recommendation on why my SQL monitor won't display the CPU Usage.

I've even tried adding a SQL Server named SRV6 which is running on Windows server SRV6 - essentially ignoring the fact that there is an availability group - but even THAT refuses to display the CPU usage.

Any recommendations are greatly appreciated.

Ken

122 1 / Create an account to join the discussion.
amin.gulamhusein
Follow / 26 Jan 2017 at 9:58pm / Toad for SQL Server
Latest post by on 27 Jan 2017 at 3:16pm

How do I find out what version of Diagnostic Server is running?

Expand content
I would like to find out what version of Diagnostic Server I'm running. I have Auto-Update setup and it doesn't seem to do anything.

I would like to find out what version of Diagnostic Server I'm running. I have Auto-Update setup and it doesn't seem to do anything.

135 1 / Create an account to join the discussion.
brumly
Follow / 13 Jan 2017 at 11:56am / Toad for SQL Server
Latest post by on 13 Jan 2017 at 9:12pm

Table not Updating in Wait Statistics View

Expand content
Hi I do the following: Enter SQL Spotlight Press the Wait Statistics button Adjust the "playback" button to the time where i had an issue I see the graph at the top and the table...

Hi

I do the following:

  1. Enter SQL Spotlight
  2. Press the Wait Statistics button
  3. Adjust the "playback" button to the time where i had an issue
  4. I see the graph at the top and the table with the statistics below.
  5. I make a note of the Wait Time Total (ms) values for the top 3 wait types
  6. On the graph i click "show data for last" -> and change the time point to 1hr or  12 hours or 1 week
  7. The graph updates with new results ok (although sometimes it doesnt)
  8. In the table, the Wait Time Total (ms) value doesnt change.

Some things i tried for troubleshooting:

  1. I tried waiting up to 5mins but no change
  2. No errors in the event viewer
  3. Memory and CPU stay well below limits for the server
  4. The waitstats_{}.result files in <install_dir>\Agent\data\memory\<db_name> look to have been updated in the last minute.. though i dont know if this has anything to do with playback data..

Questions:

  • Is this a bug?
  • If not how do i get the table to show me the statistics for what appears in the graph (i.e. the way everything else functions in spotlight)

I worry about how much i can trust these wait statistics totals...

Brumly

190 1 / Create an account to join the discussion.
brumly
Follow / 13 Jan 2017 at 10:59am / Toad for SQL Server
Latest post by on 13 Jan 2017 at 3:52pm

system.outofmemoryexception

Expand content
Hi When moving about within the Wait Events section i get: "Error retrieving data: ClientConnectIssue: Exception of type 'System.OutOfMemoryException' was thrown" How should i...

Hi

When moving about within the Wait Events section i get:

"Error retrieving data: ClientConnectIssue: Exception of type 'System.OutOfMemoryException' was thrown"

How should i start troubleshooting this issue?

Is this a problem with the spotlight server or with the SQL server that the spotlight DB sits on?

Are there any default settings for memory on the spotlight server, or for the instance that spotlight DB is running on that i should be aware of?

Cheers

Brumly

202 1 / Create an account to join the discussion.
Ken.Hemmerling
Follow / 17 Dec 2016 at 5:37pm / Toad for SQL Server
Latest post by on 10 Jan 2017 at 4:18pm

How to force Spotlight to update Index Fragmentation report

Expand content
Hello everyone, My Spotlight on SQL Server reports an index with 99% fragmentation so I used the generated script to rebuild it. That was half an hour ago and Spotlight still shows the same index with...

Hello everyone,

My Spotlight on SQL Server reports an index with 99% fragmentation so I used the generated script to rebuild it.  That was half an hour ago and Spotlight still shows the same index with 99% fragmentation.  Is there a way to force Spotlight on SQL Server to update its Index Fragmentation data?

Ken

Answered 272 4 / Create an account to join the discussion.
Gita Sharifi
Follow / 26 Oct 2016 at 7:12pm / Toad for SQL Server

What’s new for Spotlight on SQL Server Enterprise – October 2016

Expand content
This monthly publication will provide new and updated information regarding the products that we offer and organized in the following categories: Documentation, Product Notifications, Knowledgebase Articles...

This monthly publication will provide new and updated information regarding the products that we offer and organized in the following categories: Documentation, Product Notifications, Knowledgebase Articles, Product Life Cycle and Training Videos.

 

New Knowledgebase Articles

https://support.software.dell.com/spotlight-on-sql-server-enterprise/kb/212688

New enhancements and fixes of Spotlight 11.6.2 patch release.

442 0 / Create an account to join the discussion.
brumly
Follow / 25 Oct 2016 at 3:42pm / Toad for SQL Server
Latest post by on 26 Oct 2016 at 4:09pm

sys.dm_exec_connections in historic info in Spotlight

Expand content
Hi I'm specifically looking for whether num_writes is recorded as part of the sys.dm_exec_connections DMV in spotlight historic data, i.e. that i can go back to one week ago and see which query had...

Hi

I'm specifically looking for whether num_writes is recorded as part of the sys.dm_exec_connections DMV in spotlight historic data, i.e. that i can go back to one week ago and see which query had the highest num_writes?

I've looked through this forum but there are really not many posts. Neither on the blog. Is this the best resource for SQL spotlight?

The wiki is empty and the documentation on the Dell site is really thin... so struggling to find any information beyond a "getting started guide"

thanks

646 4 / Create an account to join the discussion.
Ken.Hemmerling
Follow / 19 Oct 2016 at 6:12pm / Toad for SQL Server
Latest post by on 21 Oct 2016 at 6:43pm

Collection 'SQL Cluster failover detection' failed : Execution...

Expand content
I have the following within Spotlight on SQL Server: Alarm: Monitored Server - SQL Server Collection Execution Failure Key: SQL Cluster failover detection Severity: Informational Raised: <today>...

I have the following within Spotlight on SQL Server:

Alarm:  Monitored Server - SQL Server Collection Execution Failure
Key:  SQL Cluster failover detection
Severity:  Informational
Raised:  <today>
Message:  Collection 'SQL Cluster failover detection' failed : Execution state was not set

The remainder of the message are the steps to disable this monitor.  Can anyone explain how to fix the root cause of this rather than just disabling the monitor within Spotlight?

Ken

Unanswered 752 5 / Create an account to join the discussion.
paul.bankston
Follow / 17 Aug 2016 at 4:10pm / Toad for SQL Server
Latest post by on 18 Aug 2016 at 7:10pm

Checking for High Availability Primary Replica to use in Alarm Ac...

Expand content
I have a two node SQL Server 2012 High Availability Cluster. I need to check to see which node is the Primary replica so I can configure certain Alarm Actions to only fire if the node is the Primary Replica...

I have a two node SQL Server  2012 High Availability Cluster.  I need to check to see which node is the Primary replica so I can configure certain Alarm Actions to only fire if the node is the Primary Replica.  For example, log backups only occur on the current Primary Replica so I constantly get alarms from the Secondary that the databases' logs are not being backed up.

1021 1 / Create an account to join the discussion.
colin.allen
Follow / 5 Jan 2016 at 1:59pm / Toad for SQL Server
Latest post by on 4 Aug 2016 at 8:34pm

Scripting Alarms or Alarm Actions

Expand content
I'd like to be able to script changes to alarms so that I can include the changes in deployment scripts, for example, we have two servers which flip between Production and Preproduction. When the server...

I'd like to be able to script changes to alarms so that I can include the changes in deployment scripts, for example, we have two servers which flip between Production and Preproduction. When the server is in the preproduction role we don't back up the databases, when it flips to production the backup jobs are enabled, so we only want backup alerts when the server is in the production role and we don't really want to have to manually reconfigure the alerts. Is there a way to script the changes to the exclusion list or flip the tag from production to preproduction? 

2199 1 / Create an account to join the discussion.
emil.bialobrzeski
Follow / 2 Aug 2016 at 10:28am / Toad for SQL Server
Latest post by on 4 Aug 2016 at 8:51am

Plan Pollution

Expand content
Hi, I have noticed that Spotlight is causing quite a plan pollution with his monitoring queries. SELECT query_hash , COUNT(DISTINCT ( query_hash )) AS DistinctPlanCount , COUNT(query_hash) AS PlanCount...

Hi,

I have noticed that Spotlight is causing quite a plan pollution with his monitoring queries.

SELECT query_hash ,
COUNT(DISTINCT ( query_hash )) AS DistinctPlanCount ,
COUNT(query_hash) AS PlanCount
FROM sys.dm_exec_query_stats
GROUP BY query_hash
ORDER BY COUNT(query_hash) DESC;

If you look closely at some of the top ones these are either not parameterized queries or different white spaces.

SELECT q.PlanCount ,
q.DistinctPlanCount ,
st.text AS QueryText ,
qp.query_plan AS QueryPlan
FROM ( SELECT query_hash ,
COUNT(DISTINCT ( query_hash )) AS DistinctPlanCount ,
COUNT(query_hash) AS PlanCount
FROM sys.dm_exec_query_stats
GROUP BY query_hash
) AS q
JOIN sys.dm_exec_query_stats qs ON q.query_hash = qs.query_hash
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st
CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) AS qp
WHERE PlanCount > 1
AND qs.query_hash = 0x8FD48F3C03B151EB
ORDER BY q.PlanCount DESC;

1077 2 / Create an account to join the discussion.
elizabetht
Follow / 12 Jul 2016 at 2:25am / Toad for SQL Server
Latest post by on 12 Jul 2016 at 10:56pm

Is it unwise to install spotlight on the same VM as the SQL instance...

Expand content
Hi everyone, First - apologies for what must be a noob question. I am looking to install a trial version of Spotlight to investigate DB application performance issues. We have one SQL instance (we...

Hi everyone,


First - apologies for what must be a noob question.


I am looking to install a trial version of Spotlight to investigate DB application performance issues.  We have one SQL instance (we are a small org) on a dedicated VM serving several production databases (all 3rd party).  Is it it a bad idea to install spotlight on that same VM?  Should I be looking to install it on a different VM?

Will be purchasing a full licence if it turns out to be as useful as it sounds.

(Yes I have researched this extensively, but "install" "separate", "architecture" etc are giving very broad/varied results.)

Thanks

Elizabeth

1258 3 / Create an account to join the discussion.
bkim_99845
Follow / 3 Jul 2016 at 10:40pm / Toad for SQL Server
Latest post by on 4 Jul 2016 at 3:35pm

san performance

Expand content
Hi, does anyone know how to query "max i/o wait" value from the backend database? Thanks, Ben

Hi, does anyone know how to query "max i/o wait" value from the backend database?

Thanks,

Ben

1295 1 / Create an account to join the discussion.