Datavail Experts Blog

What’s the problem?Your MySQL database was working well, humming along nicely, but quite suddenly performance went south, especially during periods of heavy usage. Maybe you’re seeing deadlocks, or it’s just incredibly slow. If your MySQL database is using InnoDB there is a good chance you need to change your InnoDB storage. If you database is using MyISAM and you’re getting table locking issues, chances are it’s time to go to InnoDB, and you need to enable file-per-table before you convert the databases to InnoDB.

The role of the DBA is an anomaly in the IT environment. DBAs are often extremely critical yet hidden from view; highly paid yet individual contributors; and very knowledgeable yet rarely consulted. So why does an extremely critical, highly paid, and very knowledgeable resource have a high risk profile for quitting? What factors can an [...]

With today's mission-critical 24×7 applications, monitoring your databases can be just as important as the actual database or DBA itself. But how do you know if your company’s current approach to monitoring is the right one? In my experience, companies tend to select a database monitoring solution based upon a DBA’s personal preference/experience often without [...]

The Database Administrator is one of the most difficult positions to fill and retain. DBAs must be able to react, communicate, and plan across many different business functions. They are not easy to find and are often shockingly costly as a percentage of IT payroll. Prior to the evolution of today’s comprehensive systems and greater reliance on data by 24×7 [...]

SQL Server Database Administrators always get to hear the age old question: How much longer will that restore or backup take?  We've always answered this question based on past experiences along with some educated "guestimations." Now, with this query you will be able to give them an answer.  Use the query below to return an [...]