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 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?
The information collected by the WorkloadAnalysis extended event is really wonderful. Is there much overhead in capturing details of each query that is run on the SQL instance 24/7? Workload analysis is enabled by default so I'm hopeful that it is very lightweight.
Hi, Spotlight Essentials reveals the SQL behind the worst performing queries in one of our instances. (See SQL below). The query is from a larger script that must allocate declared temporary tables named @Dell_EnumJobs and @Dell_JobRunDetails.
Can anyone provide sample SQL for allocating (and loading?) these table variables, so I can go about tuning the larger query?
Here is the full query:
select j.name as JobName, c.name as Category, j.enabled as Enabled, case ej.running when 1 then N'Running' else case h.run_status when 2 then N'Inactive' when 4 then N'Inactive' else N'Completed' end end as CurrentStatus, coalesce(ej.current_step,0) as CurrentStepNbr, LastRunDateTimeX as LastRunTime, dateadd(s, LastRunDurationSec, LastRunDateTimeX) as LastRunFinishTime, case h.run_status when 0 then N'Fail' when 1 then N'Success' when 2 then N'Retry' when 3 then N'Cancel' when 4 then N'In progress' end as LastRunOutcome, case h.run_status when 0 then -- combine message from job outcome (step 0) and last step that ran (select top 1 message from msdb.dbo.sysjobhistory with (nolock) where job_id = j.job_id and step_id = 0 order by instance_id desc) + N' - ' + isnull((select top 1 message from msdb.dbo.sysjobhistory with (nolock) where job_id = j.job_id and step_id > 0 order by instance_id desc, step_id desc), N'Unknown') else '' end as LastRunMessage, LastRunDurationSec as LastRunDuration, case when ej.next_run_date > 20000000 then convert(datetime, substring(ej.next_run_date,1,4) + N'-' + substring(ej.next_run_date,5,2) + N'-' + substring(ej.next_run_date,7,2) + N' ' + substring(ej.next_run_time,1,2) + N':' + substring(ej.next_run_time,3,2) + N':' + substring(ej.next_run_time,5,2) + N'.000' , 121) else null end as NextRunTime, j.description as Description, case when datediff(day,(case when ej.last_run_date > 20000000 then dateadd(ss, datediff(ss,convert(datetime,0,112), dateadd(hh,(cast(h.run_duration as bigint)/10000), dateadd(mi,(cast(h.run_duration as bigint)/10000%100), dateadd(ss,(cast(h.run_duration as bigint)%100), convert(datetime,0,112))))), LastRunDateTimeX) else null end),CURRENT_TIMESTAMP) < 8 and h.run_status = 0 and ej.running <> 1 and j.enabled = 1 then 1 else 0 end as RaiseAlarm, case when not (c.name like N'REPL-%') and c.name <> N'Replication' then case when ej.running = 1 then datediff(s, l.start_execution_date,getdate()) else null end else null end as currentrunduration, averagerunduration from @Dell_EnumJobs ej left join @Dell_JobRunDetails l on ej.job_id = l.job_id left join msdb.dbo.sysjobs j on ej.job_id = j.job_id left outer join msdb.dbo.syscategories c on j.category_id = c.category_id left outer join msdb.dbo.sysjobhistory h with (nolock) on ej.job_id = h.job_id and ej.last_run_date = h.run_date and ej.last_run_time= h.run_time and h.step_id = 0 cross apply ( select LastRunDateTimeX = case when ej.last_run_date > 20000000 then convert(datetime, substring(ej.last_run_date,1,4) + N'-' + substring(ej.last_run_date,5,2) + N'-' + substring(ej.last_run_date,7,2) + N' ' + substring(ej.last_run_time,1,2) + N':' + substring(ej.last_run_time,3,2) + N':' + substring(ej.last_run_time,5,2) + N'.000' , 121) else null end ) LRDT cross apply ( select LastRunDurationSec = case when cast(h.run_duration as bigint) > 0 then (cast(h.run_duration as bigint)/1000000)*(3600*24)+ -- incase it goes to days! (cast(h.run_duration as bigint)/10000%100)*3600+ (cast(h.run_duration as bigint)/100%100)*60+ (cast(h.run_duration as bigint)%100) end ) LRDS