Monitor all your databases from a single, intuitive console

Hey, everybody. Welcome to our webinar today. My name is Julie Hyman. I am the product manager for Quest Toad portfolio, basically our database management tool set. But Toad is our most popular brand there. So it's what I use to introduce myself so people know who I am. We know you guys are Toad customers, but what you may not understand is that Quest has a wide variety of solutions around database performance and database management. And so today, I'm going to introduce Tim Fritz, who is our product manager for our Foglight product line on performance management. Tim's going to give you a little overview of what performance management can do for you with Foglight. Take it away, Tim. All right. Thanks, Julie. Hi, everybody. Yeah, thanks for joining. Appreciate your time. And yeah, I'm going to focus on Foglight. Like Julie said, we have other performance management products at Quest, but we're going to look at Foglight. We're going to dive a little bit into Foglight to explain the 24 by 7 monitoring it does and the benefits it can bring to you. So let's dive in. So I'll start first by speculating just a little bit about your roles. As Toad users, I'm assuming that many of you are either developers or DBAs in your organization. So I'm going to speculate about some of the challenges that you're likely facing in your jobs. And I have a little bit of knowledge of that. I was a DBA before I came to Quest. So it's been a while, but I was a DBA, so I understand that role very well and things that come up. And all I can say is I wish I would have had Toad and Foglight when I was a DBA. Unfortunately, we did not. But I'll talk about the benefits that it brings. Before I do that, though, I'll talk about what it is, make sure that it's very clear what Foglight is and what it's made up of. So you, as a Toad user, let's talk about DBAs a little first. So DBAs, you are using Toad probably for schema management, et cetera, all those great things that Toad does. But how do you tackle performance issues? So you might have ways in your organization that performance issues are made known to you at this point. But one of the aspects of performance management I really, really want to go through in some detail today is the importance of understanding performance bottlenecks, so not only knowing that they're happening, but really wrapping your head around what's causing them and whether or not they really, truly are problems and then how to address them and how to get them fixed, how to find the data to help you decide what to do to fix those problems. So and then developers, you might well be responsible for performance of SQL statements that you're writing. And if you are, at some point, if there are issues with a SQL statement, that might well come back to you for some work, for some fixing, for some tuning. DBAs, one other point I wanted to make there is from experience, I know that your job performance is probably measured, at least somewhat, on the performance of the databases that you manage. So performance of the databases, of the workloads that run on the databases, it's a big deal. It's important to the organization. All right. The last point there, that last bullet on this slide, all of this is made more challenging for you probably because there are more databases coming along in most organizations now. I've got two numbers sitting there-- 10% and 90%. So the first one there is at least 10% of you-- well, no. At least 50% of you are managing more than 10% of greater volume of instances than you did last year. And so the volume of instances that you're managing has grown, and that's according to some DBTA research that was done this year. And 90% is signifying that you have probably about a 90% chance of managing more than one type of database. So platforms are growing. So new database is coming into the company. However they're coming into the company, often they're going to end up with the DBAs to support. So environments are getting more challenging. All right. So you use Toad for certain things in your jobs, but could you use it a way to solve these problems that are listed here on this slide? Maybe code doesn't run fast enough, or slowing down over time. Well, lot of reasons that could cause that. You're going to need a tool to help you do that. A chronic issue is a time-consumer because it keeps happening. You might have problems like that, right? Or one of the really, really difficult kind of problems to solve are those intermittent kind of problems that pop up now and then just suddenly. Well, what caused those? Why is this problem happening today? It happened three weeks ago. Let's try to dig in and figure that out, figure out why those are happening. All right. Another challenge, you might want to locate SQL statements that are good tuning candidates. You might want to try to focus your time on those statements that are going to be worthwhile for spending that time, that are good opportunities for improvement. Let's put it that way. You might want to find causes of blocking or deadlocks. That's a common one, database environments. Managing or writing code for multiple database platforms. I just talked about that on the previous slide. That's getting to be very, very common, and it's a challenge in many ways. Lack of visibility of performance bottlenecks. This is a huge one, especially as environments get more complex. But just having the visibility across all your different kinds of databases that you're managing and seeing the bottlenecks quickly is really important. How