Query Performance Tuning: Some Tips on What Not to Do

So far, we have covered a wide range of tips related to optimization in SQL. As a Database Administrator, you may also be aware of these and about what to do when a SQL statement results in a degradation of performance. These include the following: Using DMV for locating slow statements that take time to

Database Query Optimization & Plan Performance Tuning

Database administrators can never afford to ignore SQL database issues because the smallest ones can bring the biggest losses to the organization. At the same time, even a minor scope for change can prove to be a great opportunity for database query optimization. Although one may need a considerable amount of experience to discover such

Top SQL Query Performance Tuning Tips for Greater Efficiency

Ask anyone involved in administering and handling relational databases about the most time consuming tasks: the most common answer is likely to be coding and tuning SQL. The simple reason behind this is the presence of thousands of separate SQL queries spread throughout numerous applications that repeatedly access your multiple production databases. So, even though

Top 7 Database Query Optimization Hacks

Database query optimization is a technique through which the database performance is improved by writing thoughtful queries. During the development process, the data is less to work with. It’s easier to get results with less amount of data as compared to a large one. But the problem arises when there are loads of data flooding

Performance Tuning in SQL Oracle: High-Level DBA Tuning Tips

A database app needs regular communication between different and diverse computing resources to work productively and as per requirements. Practically, performance tuning in SQL Oracle or any other database application can be divided into 3 sections – System modifications Database tuning Application tuning These are all connected, and database performance handling needs a structured strategy

SQL Performance Tuning: Why We Should Obviate Disk Seeks

A disk seek can prove costly for DBAs for a number of reasons. Generally, a disk can carry out only up to a few hundred seek operations in a second. Therefore, database queries that elicit disk seeking will take more time and can even be exceedingly slow in certain cases.   A few approaches may actually

Improve MySQL Database Performance: Debugging Idle Connections

Do you wonder why a SHOW PROCESS LIST connection in your database has been in a sleep state for a considerably long time? If you have, you may be relieved to know that while it is still a sign of trouble, it is not an uncommon process. Why You are Getting Sleeping MySQL Connections So,

How to Improve SQL Query Performance? Some Profound Tips

Optimizing SQL query performance is an extremely intriguing subject matter between the developer and the user community. Users always seek a quick response to their data retrieval action and developers don’t lag behind putting forth their entire efforts to provide the data in the shortest time possible. However, the strangest thing is that there’s no