performance Archives

Data Proximity for Data Warehousing Performance

Data Warehousing DBAs usually work with huge tables, often possessing hundreds of millions or even billions of rows. And occasionally, these DBAs...

Top metrics to monitor in your MySQL databases

by Peter

As tables increase in size and more users come online, it becomes increasingly necessary to fine-tune your MySQL database server from time to time....

What are visual SQL tuning diagrams?

by Peter

SQL queries are the primary mechanism to interact with databases. Therefore, ensuring that SQL queries perform well is essential. An important...

SQL Performance, Part 4: Additional Considerations

by CraigSMullins

Today’s blog post concludes our four-part look into SQL performance and optimization. Part one introduced and explained relational...

SQL Performance, Part 3: Multiple Table Access Methods

by CraigSMullins

In part one of our overview of SQL performance we examined relational optimization; part two took a look at query analysis and introduced...

Performance and Quality in the RAD Studio 10.3 IDE

by David Millington

RAD Studio 10.3 has a number of performance improvements, as well as some quality improvements we’d like to share. IDE Fix Pack Some time ago, we...

How to Find and Fix SQL Server Deadlocks

by Peter

Introduction Locking is required for concurrent operations of relational databases to prevent data inconsistency and loss. However, locking impairs...

How to Monitor the Performance of MySQL and MariaDB Databases – Part 3

by Peter

This is the third part of a three-part series of blog posts. Read also the first part and second part. Analyze Queries In addition to...

How to Monitor the Performance of MySQL and MariaDB Databases – Part 2

by Peter

This is the second part of a three-part series of blog posts. Read also the first part. Click here to view the third part. Get Overview The...

How to Monitor the Performance of MySQL and MariaDB Databases – Part 1

by Peter

This is the first part of a three-part series of blog posts. Click here to view the second part. Overview SQL Diagnostic Manager for...

Five reasons SQL Server health checks are life savers

by Peter

SQL Server health checks have garnered a great deal of notoriety over the last five years. What was initially a niche offering more than ten years...

How to comprehensively manage SQL Servers on-premise and in the cloud

by Peter

The volume, velocity, and variety of data is ever-increasing. At the same time, data is becoming ever more critical to the growth of organizations....

Introduction to Windows Azure SQL Database

by Peter

Many organizations are adopting the cloud computing as their primary computing environment, and others find ways to use Microsoft Azure to enhance...

SQL Diagnostic Manager 10.3 General Availability

by Scott Stone

We are pleased to announce the general availability of SQL Diagnostic Manager 10.3. Existing users may upgrade to this version through...

How to Start SQL Server Performance Tuning

by Peter

Performance tuning is the methodology of systematically identifying bottlenecks in applications, and improving performance. There are some places to...

Indexes: Friend or Foe?

by Bert Scalzo

No matter what database you’re working with, at some point performance becomes an issue which may require further investigation into possible...

Five reasons your SQL Server is slow

by Peter

Everybody would love to find the mythical “go faster” switch in SQL Server. Unfortunately, this switch does not exist. There are, however, many...

Monitoring Master-Slave Replication in MySQL 8

by michaelcaplan

MySQL 8 introduced a number of enhancements to improve both replication performance and the monitoring thereof. Improvements included more efficient...

How to increase SQL Server performance with existing hardware

by Peter

Unlike their failed counterparts, solutions are successful solely because systems, users, and organizations have come to depend upon them. Solutions...

Setting up Basic Master-Slave Replication in MySQL 8

by michaelcaplan

Since April 19th, when MySQL 8.0 became Generally Available (GA), the MySQL community has been abuzz with excitement over all of the new features...

Analyze MySQL & MariaDB Error Log Messages using Monyog

by michaelcaplan

The MySQL error log is an essential part of database server performance monitoring. Whenever something goes wrong or performance degrades, the Error...