What’s New In SelectStar in October: New Tricks for Oracle, Treats for Cassandra and RDS
We’ve got a bounty of treats to share with SelectStar users this month–all thanks the fact that Zack and team sleep like zombies. So, get your buckets ready, it’s time to fill them up with all these spooktacular tricks that just went live.
Query Plans have invaded Oracle. Everyone is executing them.
At the start of October, we took the team out to Oracle Open World. Last year, we launched at the show. And what a difference a year makes. This year, we spent less time getting our name out and more time talking with partners (thanks, Couchbase and Redis) and customers. Those face-to-face feedback sessions resulted in several new features for Oracle database. Perhaps the most popular, we’ve added the fan-favorite Query Plans feature to Oracle.
While we’re talking Query Plans, we should let you know we’ve added two new views to all Query Plans–so you can pick your favorite–Tabular, XML, or the standard tree view. And if you’re thinking, “only my DBA gets to execute Query Plans” in SelectStar, I’ve got good news for you. We now allow all members of your team to execute query plans. This helps everyone understand the load their queries put on the database. Of course, your administrator can disable this functionality for your account, so use it wisely.
Figure 1: Pick your preferred Query plans view (tree, XML or text).
New features help you find Oracle issues scary-fast
More user-inspired features for Oracle. The Waits graph has been updated to show where waits are happening and allow you to filter views by instance, wait class and even SQL ID. These are some of my favorite visualizations to date. We’ve added our popular heatmap visualization for tablespaces to the Database Overview. Also new to the Oracle Database Overview, new data dives on latency and response time. These individual Oracle instance graphs should make it a lot easier to understand your RAC environments. Finally, we’ve added other instance-related metrics like efficiency ratios to the Relationships view.
Figure 2: Know exactly where you’re waiting with the new waits visualization
Monster improvements for Cassandra
It wasn’t all Oracle this month, we’ve also added individual node metrics to Cassandra. Now you’ll be able to drill down into each Cassandra node to see key performance metrics like latency, disk load and error frequency, as well as the node’s impact on the users and the overall cluster. We’ve also made some major improvements in the way we gather metrics, so your cluster metrics will still be available, even when you’ve got a partial outage.
New Treats for Amazon RDS
We’ve included two new widgets on the Amazon RDS Database Overview page–Tags and Snapshots. The Tags widget displays all applied tags. The Snapshots widget displays your three most recent snapshots, and allows you to drill down into a specific snapshot’s details. While you’re on the RDS Overview, you might notice the new Transaction Log Disk Usage graph.
Figure 3: Drilling down into an Amazon RDS snapshot
Other features you’ve been screaming for
To help you quickly identify which metrics are tied to the database and which are tied to infrastructure you’ll find new icons on the infrastructure performance cards. And, to make it easier to share issues, you can now link to specific alerts from the alerts tab.
If you’re thinking about trying SelectStar, now might be the best time ever. We’ve also added a demo account during the setup and configuration process, so you can test drive the latest features with live data.