PostgreSQL monitoring in Redgate SQL Monitor
I’m beyond excited to share that we’re bringing PostgreSQL monitoring to SQL Monitor and we would like to invite SQL Monitor customers to preview it.
At Redgate we’ve been watching as ever-growing numbers of organizations have embraced PostgreSQL. In particular, as we talk to SQL Monitor users, personally starting to become involved in managing PostgreSQL environments, and miss the level of visibility SQL Monitor offers for SQL Server.
We’re going to change that. We’ve been working on this for a while now, and things are shaping up nicely, so it’s finally time to lift the lid.
Where we’re going
We want monitoring PostgreSQL to look and feel just like the experience you’re used to with SQL Monitor for SQL Server. That means where the database engines share similar concepts, as much as possible we present those consistently to avoid you needing to relearn different workflows. PostgreSQL data is a seamlessly part of the same user interface, and the same install, as SQL Monitor, providing a single pane of glass over your data estate.
That doesn’t mean we’ve shied away from database-specific information where it matters. While there are a great many similarities between the database engines, plenty of concepts, like Vacuuming in PostgreSQL, or TempDB in SQL Server, are unique to one database or the other. Where it makes sense to provide additional data for those or to present things differently, that’s what we’re doing; but only where it makes sense!
To date we’ve prioritised providing the sort of diagnostic information you’re used to seeing in places like the Server Overview, to help troubleshoot performance and availability issues. Our initial focus has been on monitoring self-managed PostgreSQL instances running on Linux machines / VMs, though we’ll be expanding that over the coming months to include RDS and other DBaaS instances.
Before that though, we’re ready to start getting more input to ensure we build the most useful thing possible – with nearly 15 years of development behind our SQL Server monitoring tool, we know we won’t have total equivalence on day one. Starting in early September we’re going to run an early access program, where we’ll give an exclusive group of SQL Monitor users free preview access to the new capabilities. You’ll be able to monitor your PostgreSQL databases alongside SQL Server and with that test and evaluate our new capabilities. This will help us understand how well we’ve helped solve your most important challenges around monitoring PostgreSQL, and where we need to improve to better serve your needs. If you’re using SQL Monitor today, and have some responsibility for PostgreSQL instances, this is your opportunity to provide your input into our roadmap. If that sounds like you, we’d love to hear from you – just sign up to get early access here!
Was this article helpful?