Understanding the Fundamentals of Database Performance
Databases can be a performance bottleneck for a lot of applications, and developers and system administrators don't always understand why. This paper discusses how database engines work and what you need to look for and evaluate when reviewing your workloads. It also looks at the internal operations of the database engine, to see how they can affect overall server performance. Lastly, this eBook delve into some approaches for optimizing performance and see how to identify anti-patterns in your database queries.