Most Popular Database Performance

Why you Need a Database Performance Solution to Supplement your End-to-End Monitoring

Preface: Jez Marsh is a SolarWinds MVP and the founder of Silverback Systems U.K., a solutions provider working with customers to sharpen their operations processes and maximize their investment in their monitoring solutions. He primarily works with customers to implement SolarWinds network management software and systems management solutions but has found a growing need for […]

Read More

Understanding DB2 Performance

Making sure that database applications are running optimally is one of the biggest problems faced by DBAs on an ongoing basis. DBAs are constantly monitoring and  managing performance while also reacting to end user complaints. When users have to wait longer than they are used to waiting for their applications to respond it is understandable […]

Read More

Removing Duplicate, Repeating or Unnecessary SQL Statements in MySQL Improves Performance

Eliminating overhead that adds unnecessary load to database servers when SQL statements are unnecessary can improve MySQL performance, including removing duplicate, repeating or unnecessary statements. Removing Duplicate SQL Statements Capture of all SQL statements for a given function or process will highlight any duplicate SQL statements that are executed to complete a specific request. The […]

Read More

Tips to Improve MySQL Performance

Adding indexes can provide significant performance benefits. However, the most effective SQL optimization for a relational database is to eliminate the need to execute the SQL statement completely. For a highly tuned application, the greatest amount of time for the total execution of the statement is the network overhead. Removing SQL statements can reduce the […]

Read More

Checking and Repairing MySQL Tables

You might need to restore corrupted tables (or even an entire database) from your backups and use the update logs if a table gets damaged or deleted by accident. In case of relatively minor damage, however, MySQL provides several options for table repair. This next section deals with what you can do if this is […]

Read More

Optimizing MySQL Stored Routines

Stored routines are one of the newer additions to MySQL and, as such, are significantly less optimized than other components of the server. As a result, it’s generally not advisable for your application to rely entirely on stored routines, as doing so will likely degrade performance significantly. That said, stored routines do have a role […]

Read More