You will no longer receive e-mail notifications from this forum.
Log-In to post
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
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 Articleshttps://support.software.dell.com/spotlight-on-sql-server-enterprise/kb/214812
New enhancements and fixes of Spotlight 11.7 patch release.
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
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.
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/
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.
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.
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 do the following:
Some things i tried for troubleshooting:
I worry about how much i can trust these wait statistics totals...
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?
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?
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
New enhancements and fixes of Spotlight 11.6.2 patch release.
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"
I have the following within Spotlight on SQL Server:
Alarm: Monitored Server - SQL Server Collection Execution FailureKey: SQL Cluster failover detectionSeverity: InformationalRaised: <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?
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.
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?
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 PlanCountFROM sys.dm_exec_query_statsGROUP BY query_hashORDER 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 QueryPlanFROM ( 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 qpWHERE PlanCount > 1 AND qs.query_hash = 0x8FD48F3C03B151EBORDER BY q.PlanCount DESC;
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.)
Hi, does anyone know how to query "max i/o wait" value from the backend database?