Comments
Sort by recent activity
Hi @SEarle86, Appreciate we've been dealing with this on an internal ticket but just wanted to add an additional response here for anyone else who might be seeing an issue with high CPU after updating past 13.0.24 Our development team are currently investigating what they believe might be behind the CPU issue observed, although this may look similar to the query originally reported by Don on this forum post it is a different issue. If you find this forum post and are experiencing the same symptoms (on 13.0.25 or later) we would encourage you to log a ticket with support for us to gather some additional information for diagnosis. Hope to have an additional update here soon with further information on this. / comments
Hi @SEarle86,Appreciate we've been dealing with this on an internal ticket but just wanted to add an additional response here for anyone else who might be seeing an issue with high CPU after updati...
Hi @Thomas_C Sorry you've seen this issue with SQL Prompt, can you advise what version of SQL Prompt and SSMS you are currently using if you believe the issue still persists? Additionally, you mention another thread in your last post here, can you provide a link to this if this is another forum post as I'm unable to locate it. / comments
Hi @Thomas_CSorry you've seen this issue with SQL Prompt, can you advise what version of SQL Prompt and SSMS you are currently using if you believe the issue still persists?Additionally, you mentio...
Hi, From the information provided, it's difficult to see exactly where the issue is here and this could be potentially caused by a range of things. Can I ask you to try adding the SQL Server to SQL Monitor even though the test fails? Then once added, please navigate to Configuration>Monitored servers and check the instance to see if the same error is flagged. To do this you can select the "Show log" option in "Monitored servers". Have messaged you directly via our ticketing system so we can have a look at your logs without you needing to post anything publicly on the forum. Once we've resolved will post again here for anyone else looking to resolve this issue. / comments
Hi,From the information provided, it's difficult to see exactly where the issue is here and this could be potentially caused by a range of things. Can I ask you to try adding the SQL Server to SQL ...
Hi Ben, Checking for index fragmentation is a very resource-intensive activity. For this reason, SQL Monitor only checks for fragmented indexes once a week: on Sunday at 01:00 (by default). This means that an alert may remain Active for some time after you fix the issue, and will only be updated after the next scheduled weekly check. https://documentation.red-gate.com/sm13/list-of-alerts-195789424.html#Listofalerts-Fragmentedindexes There is a way to change when this runs (if you had other processes, scans etc happening in your environment that were consuming resource) but at present there isn't a way to increase frequency. I would suggest raising this request on the UserVoice site, votes on these suggestions can help prioritise future features! / comments
Hi Ben,Checking for index fragmentation is a very resource-intensive activity. For this reason, SQL Monitor only checks for fragmented indexes once a week: on Sunday at 01:00 (by default).This mean...
Hi Nicki, At present we don't have this functionality out of the box and I can't see a way of achieving this. I would suggest raising this request on the UserVoice site, votes on these suggestions can help prioritise future features! Apologies I can't offer you a solution to this currently. / comments
Hi Nicki,At present we don't have this functionality out of the box and I can't see a way of achieving this.I would suggest raising this request on the UserVoice site, votes on these suggestions ca...
Hello Hein, At present this is a limitation in the design of this "Summary" report tile. I would suggest raising this request on the UserVoice site, votes on these suggestions can help prioritise future features! Apologies I can't offer you a solution to this currently. / comments
Hello Hein,At present this is a limitation in the design of this "Summary" report tile.I would suggest raising this request on the UserVoice site, votes on these suggestions can help prioritise fut...
Hi Sanjiv, Doesn't look like this is functionality that we currently have. The Code Analysis tool from server Overviews will provide suggestions for improvements in queries. [image] [image] To specifically see rows returned, I would suggest raising this request on the UserVoice site, votes on these suggestions can help prioritise future features! / comments
Hi Sanjiv,Doesn't look like this is functionality that we currently have. The Code Analysis tool from server Overviews will provide suggestions for improvements in queries.To specifically see rows ...
Hi, Apologies for the lack of update here, a colleague had reached out back in April with an internal ticket to request some additional information, can you advise if you still require assistance with this issue in Source Control? / comments
Hi,Apologies for the lack of update here, a colleague had reached out back in April with an internal ticket to request some additional information, can you advise if you still require assistance wi...
Hi, While we don't have this functionality directly within SQL Monitor with do have some documentation for a third-party tool called PagerDuty. Please find link for this below as well as additional documentation from their site. https://documentation.red-gate.com/sm/metrics-alerts-and-notifications/configuring-alert-notifications/setting-up-email-notification/pagerduty-sms-notifications https://www.pagerduty.com/docs/guides/red-gate-sql-monitor-integration-guide/ Hope this is useful, please let us know if anything further is required. / comments
Hi,While we don't have this functionality directly within SQL Monitor with do have some documentation for a third-party tool called PagerDuty. Please find link for this below as well as additional ...
Hi Paul Unfortunately, SQL Compare does not provide a global setting to remember the ignored constraint names or extended properties outside of a project. However, you can create a project file in SQL Compare and save the settings for ignored constraint names and extended properties within that project. This will allow you to reuse the same settings in future comparisons without having to manually configure them each time. To create a project file, simply open SQL Compare and select "File" > "New Project". Then, choose your source and target databases, and configure the options as desired, including the ignored constraint names and extended properties. Once you have configured the project, save it as a project file for future use. You can open the project file and run a comparison to use the same settings. Hopefully this will save you time and effort in manually configuring the options each time you run a comparison. Appreciate this isn't exactly the solution you were asking for, if this isn't sufficient for you I would suggest raising this request on the UserVoice site, votes on these suggestions can help prioritise future features! / comments
Hi PaulUnfortunately, SQL Compare does not provide a global setting to remember the ignored constraint names or extended properties outside of a project. However, you can create a project file in S...