Why Alerting Tools Often Fail Administrators

post date May 04, 2012
post author SQLRockstar in Database Performance, Ignite, Performance Tuning
post date Tweet This
post comments No Comments

I have smoke detectors in my house.
They are really good at telling me when there is smoke, or a fire, providing I keep fresh batteries in them of course.
They are really lousy at preventing smoke, or fires, from happening in … Continue reading →

Collect and Alert on Deadlocks for MS SQL Server With Ignite

post date Apr 30, 2012
post author SQLRockstar in Database Performance, Ignite, MSSQL
post date Tweet This
post comments No Comments

Ignite can collect a count of the number of deadlocks to be displayed as a resource graph. For Ignite version prior to 8.2, you can update two files in order to start collecting the number of deadlocks. The code below … Continue reading →

IgniteVM Review – Yes It Is That Cool!

post date Mar 09, 2012
post author SQLRockstar in AlarmVM, Database Performance, DB2, IgniteVM, MSSQL, Oracle, Sybase, Virtualization
post date Tweet This
post comments No Comments

Eric Sloof (blog | @esloof) posted some videos of IgniteVM and AlarmVM today and we wanted to share his post with you here.
I won’t give you a transcript of the videos but will share with you some of the quotes … Continue reading →

One Reason Why IgniteVM is better than vSphere

post date Jan 30, 2012
post author SQLRockstar in Database Performance, Ignite, MSSQL, Oracle, Performance Tuning, Response Time Analysis, Virtualization
post date Tweet This
post comments No Comments

I hate wasting time. And if you are like me, you hate wasting time as well. And I *know* your end-users hate watching you waste time when trying to find the root cause for performance problems.
As an example let’s look at one … Continue reading →

Do You Make These 5 Database Design Mistakes?

post date Jan 16, 2012
post author SQLRockstar in Database Performance
post date Tweet This
post comments No Comments

Look, everyone makes mistakes. It’s true. But not all of us have the chance to make mistakes that end up costing millions of dollars in hardware and production support costs.
Any one of the following five mistakes listed below will add additional … Continue reading →

Ignite: What To Do When OEM Breaks

post date Dec 02, 2011
post author SQLRockstar in Database Performance, DB2, Ignite, MSSQL, Oracle, Performance Tuning, Response Time Analysis, Sybase
post date Tweet This
post comments No Comments

There are some days when a stroll down memory lane is most welcoming, and today is one of those days as I read this blog post written by Kyle Hailey: http://dboptimizer.com/2011/12/01/confio-ignite/
When I read that post it reminds me of myself about … Continue reading →

Confio Software Now Listed As Partner For VMWare

post date Aug 30, 2011
post author SQLRockstar in Database Performance, Ignite, Performance Tuning, Virtualization
post date Tweet This
post comments No Comments

Last week I got the news…something that we were working towards finally happened: Confio is now a Professional level partner in the VMware partner program,  and our listing was just cleared for display on their site.  You can go see it … Continue reading →

Why Ignite Uses SQL Server Trace Flag 2861 and Zero Cost Plans

post date Aug 09, 2011
post author SQLRockstar in Database Performance, Ignite, MSSQL
post date Tweet This
post comments No Comments

OK, first thing first, what is a “zero cost plan” in SQL Server? The easiest thing to do is to say “it’s a plan with zero cost”, but that didn’t seem to be enough detail for me here. So I … Continue reading →

Performance Tuning and Time Invested

post date May 04, 2011
post author SQLRockstar in Ignite, Performance Tuning, Response Time Analysis
post date Tweet This
post comments No Comments

I never cared for the phrase “wasted time” when it comes to something like performance tuning. Sure, we all feel that way, especially when we spend hours on something only to find we were heading down the wrong rabbit hole … Continue reading →

Wait Statistics are the Bread and Butter of Performance Tuning

post date Apr 14, 2011
post author SQLRockstar in Database Performance, Ignite, Performance Tuning, Response Time Analysis
post date Tweet This
post comments No Comments

Yes, it’s true. Don’t believe me? Fine then, would you believe Paul Randal?
It’s a simple fact, really. If you know what your queries are waiting for, then you know how to improve performance. And that is why customers LOVE Ignite, … Continue reading →