Databases

Maximizing Database Performance – MySQL Tuning Best Practices

With the added complexity of growing data volumes and ever changing workloads, database performance tuning is now necessary to maximize resource utilizations and system performance. However, performance tuning is often easier said than done. Let’s face it, tuning is difficult for a number of reasons. For one thing, it requires a significant amount of expertise … Read more Maximizing Database Performance – MySQL Tuning Best Practices

Must-know Tips and Tools for Oracle Virtualization

These days, even business-critical applications are being virtualized, and with the increasing costs and complexity of data environments, it’s not surprising. Some estimate that large organizations are as much as 70% virtualized already, with no plans to go back to physical servers. Virtualization, however, introduces new challenges for the Oracle DBA, including getting visibility to … Read more Must-know Tips and Tools for Oracle Virtualization

SQL Server Performance Tuning Tips

Query tuning is often the fastest way to accelerate SQL Server performance. Most often system-level server performance (memory, processors, and so on) improvement measures are ineffective and expensive. Expert developers believe most performance issues can be traced to poorly written queries & inefficient indexing, not hardware constraints. In fact, some performance issues can only be … Read more SQL Server Performance Tuning Tips

SQL and Database Performance Tuning Guide and Checklist: Expert Tips

A Database Administrator (DBA) is like a racecar technician. Building and optimizing a high-performance vehicle requires minuscule fine-tuning and attention to detail. A tweak here and an adjustment there could shave just a fraction of a second from your lap time. Of course, that fraction of a second could determine whether you win or lose … Read more SQL and Database Performance Tuning Guide and Checklist: Expert Tips

Subjectivity: Naming Standards

Naming conventions are a very subjective thing, of course. Just like coding styles, they can often lead to anything from minor debates to full-blown religious arguments. Upper case vs. lower case keywords, tabs vs. spaces, and where to put commas come to mind. Heck, these same people even get into sub-arguments about whether the terms “upper … Read more Subjectivity: Naming Standards

Monitoring for Suspect Pages

Recently I have spoken with a number of people about the key things that they monitor when it comes to SQL Server, with the key metrics CPU, Memory, and I/O mentioned. Some others set up alerts for specific errors or severity of errors, however one thing that comes up very rarely is monitoring for Suspect … Read more Monitoring for Suspect Pages