Pini Dibask highlights key features of Foglight for Cross-Platform Databases at Oracle OpenWorld

Hello, everyone. Welcome to Quest booth. Thank you very much for joining. My name is Pini. I'm from Israel. You probably noticed that I have an interesting accent. So I'm from Israel. I work for Quest as a product manager for database performance monitoring. And in today's presentation, we are going to cover [? Foglight ?] databases. So let's start with a quick story. These three numbers, 68, 80, and 70, these numbers represent what we're seeing in the database markets. And this is actually based on a recent survey that we conducted, which shows that 68 of the organization have an increasing number of databases per DBA. So if in the past, a decade ago, one DBA was responsible for five or 10 databases, and some of our customers were seeing DBA's who manage hundreds of databases. 80% of DBA's are responsible for three or more platforms. In other words, gone are the days that DBA's were just Oracle or just SQL server. Now what we're seeing in our customer base, it's Oracle with Mongo, with Cassandra, open source databases such as PostgreS, MySQL, and others. 70% of DBA's consider performance tuning the most challenging and their most important responsibility. This is exactly what we're doing with Foglight. So Foglight a cross-platform database monitoring solution. It covers commercial databases like Oracle, SQL Server, DB2, open source databases, MySQL and PostgreS and also NoSQL solutions, non relational solutions, like MongoDB and Cassandra. This is the global view where you can see all of the databases, all of your distributed environment in one dashboard. So if we basically break it down by different categories, we have the traditional relation now. We have the NoSQL databases. We have the open source, and we have cloud databases. And as mentioned earlier, what we're seeing in our customer base is, today's companies, today today's organization, they have all of that. It's not just Oracle or just SQL Server anymore. If we talk about the database monitoring markets, database monitoring the market in general, all the other solution that provides monitoring and coverage, then we can break it down by different categories. The y-axis represents depth-- how deep dive information they provide, how focus they are, how many capabilities they can cover. The other one is bredth-- how broad the solution is, how heterogeneous it is. So what we're seeing is that all of the solutions out there that are either deep, they provide deep dive diagnostics. But they are narrow. It means that they are focused only on one tool. We also see some solutions that out there, which are wide. They are heterogeneous, but they're all very shallow. The coverage for database monitoring is very basic. And today's DBA's, for them, it's not enough to know if the database is up or down. It's much more than that. They need deep dive performance analytics. And this is exactly what we are doing in Foglight. Foglight is the only solution in the markets that provides cross-platform coverage for different types of databases without sacrificing the depth of the data and the capabilities for DBA's, the advanced capabilities. So when we talk about deep dive, what it actually means is that we cover all the different aspects of databases, whether it's storage, memory, execution plans, alert log, reporting, basically every aspect, high visibility, disaster recovery. Every aspect in database is being covered by us. So let's talk about Oracle. We're in the Oracle OpenWorld. So we are going to focus on about the Oracle monitoring for today. What Oracle DBA's do today when they don't have the diagnostics back, for them it's very challenging because the only tool that they can use is Statspack, which is a text based report, no navigation, no visualization. In other words, if you're an Oracle DBA and you don't have the diagnostic specs in the Enterprise Edition, you're basically struggling every day because you don't have any visualization or any visibility into database performance. All of the great features that Oracle provide like AWR, ASH, ASH Analytics, all of those are only available with a diagnostic stack. We decided to make sure that Foglight allows DBA's to get all the performance diagnostics they need without breaking the bank, without spending a fortune. We are basically-- we're basically provided the diagnostic spec alternatives because we cover all of the different aspects of monitoring with remote agent-less architecture. We can monitor hundreds of databases remotely without installing any local agent on the [INAUDIBLE] hosts, which makes the deployment very easy, very straightforward. So again, we support all database additions and configurations. Whether on premise, cloud, rack environments, single instance, everything is covered. Let's talk about some of the deep dive analytics capabilities that we offer. Multi-dimensional drill downs, we basically took all of the database activity, and we broke them down by different dimensions such as the SQL statements. Most tools out there, the only thing they can do is say which are the top statements? Which are the top SQL statements which consume most of the activity? But it's not enough. We want to provide much more than that. We want to provide the programs, the users, the batches, the objects, the files, the disks. We want to break down the activity by different dimensions. So in this case, we can see all the statements, which were executed by program [INAUDIBLE] that was running under user sales at any point in time. So we basically can do the drill down, slice and dice roll up operations, all of the analytic operations on top of the performance cube, on top of the performance data. Another very sophisticated algorithm that we have is the baseline algorithm. What we developed in Quest is a very unique baseline algorithm because unlike other tools, which can tell you what is the behavior, the workload compared to a specific point in time, like Monday between 2 to 4 PM, we know what is the expected behavior of the database and the infrastructure like the memory CPU and disk at any point in time. So we are sensitive to point in times like hour in a day, the day in the week, the week in a month, and so on. In this case, we can see that this is the range. This is the baseline range. It's between zero to two average active sessions. And as you can see, there is no baseline deviation. Once we find a baseline deviation, we can alert the organization, the DBA team. We have change tracking, so we can correlate any changes like execution plan changes, configuration changes, schema changes. All of those changes, we basically collect them. And we show you, every time we find those changes on top of the [? workload ?] chart, this way you can visually correlate between the changes and the actual workload. And this is the only tool in the market that can provide this kind of a visualization that allows you to understand what is the root cause for any performance issue in the application. In some cases, use [INAUDIBLE] dropped an index. And therefore, the execution plan was changed, and that's why suddenly there is a peak in [INAUDIBLE] activity. There is an increase. The compare is another big feature. So in many organizations, they would like to compare between different environments, such as the production and the development, especially in today's DevOps era. Also you may want to compare between different dimensions, user HR to user cells, one SQL statement to another. You can do all of that as part of the compare tool. And this is another very unique tool in the market. So as mentioned, it's not just cross platform. It's also very deep dive analytics for each one of the supported databases. What we've seen so far-- this is just the basic stuff. We have much more-- we have execution plan analysis, I/O analysis. We have historical [? blocking block ?] analysis. We have enterprise and single instance reporting. We have Enterprise customizations. So if you would like to learn more, we have a demonstration here. So feel free to come and see a demo, a live demo. Don't just take my word for it. This is what our customers say. So this is some customer success stories, customer quotes. Using [? PostgreS ?] with Oracle Standard Edition to decrease OEM license costs and still provides vision into system health and upcoming problems. Foglight has helped me in my role as a IT professional by saving time on monitoring Oracle databases. Foglight helped me by providing me a centralized view of my entire distributed database environment. So these are some of the things that our customers say. Any questions about the product? OK, again, we have a demonstration. Feel free to come to see the live demo. Thank you very much for listening.