Monitoring Disk Queue Length

Monitoring Disk Queue Length

Recently, I wrote a blog post about performance counters and why the threshold depends (Performance Counters: Why It Depends). In this post, I talked about why the counter Disk Queue Length is no longer a valid counter to use. Today, I want to elaborate on that and...

Executing Explain Plans Using Rapid SQL by Dan Hotka

Executing Explain Plans Using Rapid SQL by Dan Hotka

This is a guest post from Dan Hotka, Oracle ACE Director. Learn more at his webinar Explain Plan Tips and Techniques. Hi! My name is Dan Hotka. I am an Oracle ACE Director. One of my many charters with this group is to help spread the good word and technical knowledge...

SQL Heatmap is here – Idera’s newest free tool

SQL Heatmap is here – Idera’s newest free tool

Idera strives to bring helpful tools to the market for DBAs and Developers to complete daily tasks and a variety of these are free. Today we announce our latest free tool, SQL Heat Map, which displays SQL Server capacity utilization in one simple snapshot view. A...

Seven Deadly Sins of Database Design

If you don’t get the data right, nothing else matters. However, the business focus on applications often overshadows the priority for a well-organized database design. Addressing some simple data modeling and design fundamentals can put you on the right path. Here are...

Quickly grouping events in SQL XEvent Profiler

Quickly grouping events in SQL XEvent Profiler

As you may know, Idera has a number of free tools for SQL Server and we’re always coming out with new ones. Earlier this year we debuted SQL XEvent Profiler, a little tool that uses XEvent technology but emulates the workflow of SQL Profiler to make it quick and...

Survey: Oracle in your environment

A recent survey indicated a significant number of our customers use Oracle in their environment. Please help us better understand how we can help you by filling out this brief survey. There are no wrong answers, and you’ll be helping us to plan the next releases...

Precise for web shows only a location of All

You may notice that in Activity tab in Precise for web your location data only shows a Location Name for All. Although Precise is designed to show multiple locations currently you must define the IP range of locations in your environment. This can be somewhat...

Survey: What database platforms are you using?

We are always looking for feedback to ensure we produce products that make your job easier. We’d very much appreciate if you’d take this short survey to let us know what database platforms are in use in your organization. As a thank you, we’ll send you a $5.00...

DBAs and Dinosaurs

DBAs and Dinosaurs

You have to admit that title is catchier than yet another “Death of the DBA” blog.  And that was exactly the direction I was headed until I ran a quick search to find a reference that not only exposed actual predictions of the death of the DBA as a profession but also...

SQL diagnostic manager Secrets: Configuring Alerts

There are a lot of features in SQL diagnostic manager. In this series, I plan to let you know about features that many users never find. In today’s article I want to talk about some of the capabilities around managing alerts that you may not have discovered....

Time for an Upgrade?

Time for an Upgrade?

I don’t know about you, but deciding when to pull the trigger on an upgrade is not that easy for me.  What is to be upgraded usually doesn’t matter either, be it IT related (software, hardware) or the latest smartphone or TV, I typically wrestle with the...

Survey: Idera’s new SQL Server job management solution

We are currently working on a new SQL Server agent job monitoring and management tool, to become available later this year. This first release will offer the following features: Agentless monitoring of SQL Server agent jobs Centralized job management including the...