Activity overview
Latest activity by PeterDanielsCRB
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 ...
Is SCA going away?
Not seeing much new dev for SCA, and in the main redgate web page, it's not even listed under products. Do we need to be rethinking our DB devops strategy? Flyway enterprise? we've been using sca f...
Azure Data Factory, Synpase, Azure SQL Database, and SQL Change Automation
Hello!We are moving more of our work away from on-prem SSIS into synapse/ADF and using Azure SQL DB. This is great, but we are also using SCA. This was working OKish when developing ETL in SSIS, ev...
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...
Getting frequest SQL Authentication Failed alerts for one server
SQL Monitor 11.2.11.14502Getting somewhat frequent (maybe hourly or so) Monitoring Stopped (SQL Server Authentication) alerts that go away within roughly a minute. This is only happening for one se...
Simpler ways to add additonal built-in performance counter metrics?
SQL Monitor 11.2.11.14502I am familiar with custom metrics and have added a few. However, I often just come back to, "It should be simpler than this". For example, I wanted to look at "SQLServer Bu...
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...