Comments
Sort by recent activity
Thanks, @Jon_Kirkwood. Phillip Keebler already got in touch with me. We're just trying to find a time window to meet. I will admit that I (and my manager) will be a little upset about having to add more $ to get flyway licenses on top of the toolbelt and SQL monitor $ we are spending. Let's hope that is not the case. / comments
Thanks, @Jon_Kirkwood. Phillip Keebler already got in touch with me. We're just trying to find a time window to meet. I will admit that I (and my manager) will be a little upset about having to a...
Thank you, @Jon_Kirkwood. I think a convo with our sales rep (for crbusa/crb group) will be helpful. I'm trying to track down who that is now. I'm especially curious about how the newer tools will fit in with a more cloud-centric architecture (ADF/syanpse/Azure SQL/Lakehouse/etc.) Quick question: will our existing full SQL Toolbelt licenses give us access to all of the new flyway tools? / comments
Thank you, @Jon_Kirkwood. I think a convo with our sales rep (for crbusa/crb group) will be helpful. I'm trying to track down who that is now.I'm especially curious about how the newer tools will ...
Thanks for replying, @ATurner. This was primarily one SQL Instance on one machine (on prem VMWare VM), but we did get a few for another VM on the same host. I was guessing it wasn't a SQL Monitor, issue but wanted to investigate multiple avenues and wanted to see what tools y'all might use for troubleshooting these particular network connectivity issues. I should add that we experienced more than the "Monitoring Stopped (SQL Server Authentication)" alerts. We also saw: Monitoring error (host machine data collection) Monitoring error (SQL Server data collection) Machine unreachable It is starting to look like we had some network saturation goin on when these errors occurred, so considering the errors have not resurfaced since, I'm somewhat confident that was the issue. However, I do think that the "Monitoring Stopped (SQL Server Authentication)" is not really appropriate. This would suggest that the monitor could connect, but actually failed authentication, so I would like the team to consider looking into that. / comments
Thanks for replying, @ATurner. This was primarily one SQL Instance on one machine (on prem VMWare VM), but we did get a few for another VM on the same host. I was guessing it wasn't a SQL Monitor, ...
Thank you, Jon. I added a comment to that user voice, although it feels a little odd trying to bump up a UV whose last comment was 2013. [image] I will take a closer look at the "Use rate of change" option. Was not aware of that...thank you! Regarding your final sentence, I also have considered some more complex custom efforts to sample these additional metrics in a way that SQL Monitor could more easily consume, but it just seems like that is a bit of a hack. Thanks for all you do! -Peter / comments
Thank you, Jon. I added a comment to that user voice, although it feels a little odd trying to bump up a UV whose last comment was 2013. I will take a closer look at the "Use rate of change" optio...
Well crap. It also set all of them to "enabled" even though I didn't choose this... / comments
Well crap. It also set all of them to "enabled" even though I didn't choose this...
OK - figured it out. In Configuration | Alert settings, I have to select the server, then select all of the alerts (the key), then click "Configure Alerts". Then, I can choose "Customize settings for this level and all levels below" and change the email addresses. / comments
OK - figured it out. In Configuration | Alert settings, I have to select the server, then select all of the alerts (the key), then click "Configure Alerts". Then, I can choose "Customize settings...
Thanks for the response, @Alex B. I do like the idea of "hacking" the alert/custom metric system by using the alert.annotations table, but it does feel a little kludgy. It would be cool if we could define more "event"-based alerts rather than just metric-based. I realize there is a bot of a fuzzy line between them. [image] Thanks again for all your help! -Peter Ps This is driven by some efforts into monitoring and alerting on our power bi and AAS dataset refresh processes (and other bits), which may really just be outside of SQL Monitor's scope. It would be nice, though. [image] / comments
Thanks for the response, @Alex B. I do like the idea of "hacking" the alert/custom metric system by using the alert.annotations table, but it does feel a little kludgy. It would be cool if we coul...
I upgraded to the latest version (11.1.x). Still didn't see the Azure SQL DB...until I selected a metric within the "Azure SQL Database Metrics" section. [image] / comments
I upgraded to the latest version (11.1.x). Still didn't see the Azure SQL DB...until I selected a metric within the "Azure SQL Database Metrics" section.
I figured it out. First, I tried just adding: -DriftFltering AllObjects Still do luck, so I tried creating a build artifact to use as -Source instead of using my local dev DB. This gave me a helpful error: "Error performing schema comparison: The database snapshot was saved by a newer version of SQL Compare" So, I updated my SCA install (actually my whole SQL Toolbelt), and now I am getting the full drift html report and the DriftRevertScript.sql. Cool. Thanks again, Kendra! Cheers, -Peter / comments
I figured it out.First, I tried just adding:-DriftFltering AllObjectsStill do luck, so I tried creating a build artifact to use as -Source instead of using my local dev DB. This gave me a helpful ...
Thank you, Kendra. All prod deployments happen via Azure DevOps release pipeline, which uses the Redgate SCA plugins. I just checked, and did see a single row in the dbo.__SchemaSnapshot table from the latest deployment. I wonder if I need to use the source project instead of my local dev DB when using New-DatabaseReleaseArtifact. Or if I even need to make a build artifact. I def considered just using SQL compare, too. Was just hoping to see the drift report in action. [image] I will also try using -DriftFiltering AllObjects. Cheers, -Peter / comments
Thank you, Kendra.All prod deployments happen via Azure DevOps release pipeline, which uses the Redgate SCA plugins. I just checked, and did see a single row in the dbo.__SchemaSnapshot table from...