performance

Postgres at Any Scale

This presentation starts with the basics you need to know as an app developer about interacting with your PostgreSQL database. Then, it digs into how you can start to analyze performance. You will learn what you need to know for a small application, then the things you should be cautious of as you start to …

Postgres at Any Scale Read More »

Practical MySQL Performance Optimization

This presentation discusses how to get great MySQL performance while being practical – spending time on what gives you the best return. It covers the main areas for improving MySQL performance, pointing out the most important things you need to get right for each of them.

Capturing SQL Server Deadlocks

If you are experiencing deadlocks in SQL Server, you want to know more about them. What queries are causing them? What tables and indexes are at the root of the problem? You can find this information by using tools such as trace flags, Profiler, and Extended Events.

MySQL Performance with TokuDB

Gerry Narvaja of Tokutek discusses Performance at Scale with TokuDB. TokuDB is an open source, high-performance storage engine for MySQL and MariaDB that dramatically improves scalability and operational efficiency. TokuDB is for Big Data applications with demanding requirements that are not met by the your current storage engine, and reduces the deployment costs associated with …

MySQL Performance with TokuDB Read More »

Slowing Down SQL Server Queries with Parameter Sniffing

You have heard the term ‘parameter sniffing’, but you’re always a little bit fuzzy on the details. Is this a bug in SQL Server? Could it be happening to you? This video explains the truth about this complex and often confusing feature in SQL Server.