Category Archives: performance

A New and Improved Navicat Monitor

DBAs are always looking for ways to better manage the performance of their database systems and the applications that access those databases. Indeed, monitoring and tuning are perhaps the most frequent tasks that DBAs perform. So, it makes sense that … Continue reading

Posted in DBA, performance, SQL | Leave a comment

SQL Performance and Optimization

Just a quick post today to refer my readers to a series of blog posts that I recently made to the IDERA database community blog. This four-part blog series took a look into SQL performance and optimization from a generic … Continue reading

Posted in optimization, performance, SQL | 4 Comments

Database Performance Management Solutions

Performance management, from a database perspective, is comprised of three basic components: Monitoring a database system and applications accessing it to find problems as they arise. This is typically referred to as performance monitoring. Analyzing performance data (logs, trace records, … Continue reading

Posted in DBA, performance, tools | Leave a comment

DBA Corner

Just a quick blog post today to remind my readers that I write a regular, monthly column for Database Trends & Applications¬†magazine called DBA Corner. The¬†DBA Corner is geared toward news, issues, and technologies that will be of interest to … Continue reading

Posted in DBA, NoSQL, performance, SQL | Leave a comment

Don’t Forget the Free Space

When you design your databases you must take care to specify appropriate free space to allow for data growth. Free space, sometimes called fill factor, is a DDL option that can be specified when creating or altering your table spaces … Continue reading

Posted in database design, DBA, free space, performance | Leave a comment

Monitoring MySQL and MariaDB Instances

Database performance monitoring and tuning is one of the biggest DBA responsibilities. The old maxim that if something can go wrong, it will, seems to be the general rule in the world of database administration. So, DBAs need effective tools … Continue reading

Posted in MySQL, performance | 3 Comments

A High-Level Guide to SQL Tuning

SQL tuning is a complicated task and to cover it adequately requires a full-length book of its own – actually, perhaps several if you use multiple DBMS products. That said, there are some good high-level SQL tuning suggestions that should … Continue reading

Posted in performance, SQL | 1 Comment

SQL Coding and Tuning for Efficiency

Coding and tuning SQL is one of the most time consuming tasks for those involved in coding, managing and administering relational databases and applications. There can be literally thousands of individual SQL statements across hundreds of applications that access your … Continue reading

Posted in books, performance, SQL | 2 Comments

A Good Start for Your SQL Library

Every professional programmer (and DBA) should have a library of books on SQL fundamentals. There are many SQL titles to choose from, and a lot of them are very good. But you can’t buy them all unless you are independently … Continue reading

Posted in books, DBA, performance, SQL | Leave a comment

A Database Performance Tuning Primer

In a recent series of posts to this blog I outlined a dozen SQL rules of thumb to follow as you design and code your database applications. These articles can be found at the following links: A Dozen SQL Rules … Continue reading

Posted in performance | Leave a comment