Webinar

Building a Database Monitoring Tool using Splunk

Database Monitoring Webinar

 splunk_web
Is your database environment in need of a custom-built monitoring tool? Splunk may provide the answer. In this webinar, we will show you how to build a Database Monitoring Tool for free using both SQL scripts and shell scripts. The examples will be based on Oracle SQL however they can easily be translated into DB2, SQL Server, MySQL or any other major database platform.

You can monitor sessions, disk performance, SQL performance, DB tablespace information, concurrent programs and object statistics…all using one single script and Splunk – for free! Don’t miss this opportunity to learn how.

Complete the form to watch the video instantly >>

Show Transcript

Below is a preview of the webinar transcript.

Why Splunk? Everyone hears a lot about big data today, and when we think about big data, we think about three things: the volume of data, the velocity and the variety of data. With all the databases, whether we’re talking about SQL Server or Oracle or MySQL, how [inaudible 00:02:51] databases, but there’s all this meta-data that exists for all the environments that we have, and there’s a lot of it. It’s being recorded very quickly, and it’s different. It’s all different. How do we put it somewhere so that we can visualize it, we can monitor it and we can make sense of it?

Splunk is a great tool for that; although Splunk is not a monitoring tool per se, I’m going to show you how you can use it to monitor databases. I have a little quote here and I’m just going to read a little of it at the bottom, from Mac Slocum’s “Big Data.” “The art and practice of visualizing data is becoming ever more important in bridging the human-computer gap to mediate analytical insight in a meaningful way.” When we ask the question, “Why would we use Splunk?” Splunk is great for unstructured data. It’s great for big data. It’s great to monitor all this meta-data that we have out there, that is not consistent, that we’re getting just a load of it and we have a lot of it.

Fill out the form to the right to watch the webinar in its entirety. >>

Related Resources

Building a Database Monitoring Tool Using Splunk

Whenever you are performing large-scale ETLs, you want both the source and the target to be tuned as much as possible. Datavail often will use a 5S approach to tuning databases. This presentation deck includes some high level ideas on how to tune your ETLs.

Download now