What Do You Mean By Database Performance?
Ensuring optimal performance is one of the most important goals of IT professionals. And for DBAs, tuning and monitoring are often daily tasks. But there are many factors involved in properly optimizing, monitoring, and tuning databases and the applications that access them—too many to do the topic justice in a single column. Nevertheless, we can address the basics!
Even in today’s modern IT environment, performance management is often conducted reactively instead of proactively. You know the drill. A client calls with a response time problem. A table space maxes out on extents. A program is running without taking commits causing all kinds of locking problems. Somebody changed an application package without checking on the new access paths and transactions are slower than before. And then somebody submitted that “query from hell” again that just won’t stop running. Sound familiar? All too often DBAs are being asked to respond reactively to …
What Do You Mean By Database Performance? Read More