有什么资源用于数据库性能调整？ [英] What resources exist for Database performance-tuning?

问题描述

有什么好的资源可以理解主要引擎上的数据库调整，并提高你在该领域的知识。

What good resources exist for understanding database tuning on the major engines and advancing your knowledge in that area?

这个问题的想法是收集shed负载资源总是存在的，所以人们可以有一个一站式知识商店的良好，同行批准的资源。

The idea of this question is to collect the shed load of resources that invariably exist, so that people can have a "one stop" knowledge shop of the good, peer approved resources.

一般SQL

• Book：SQL Performance Tuning


• Book：SQL Tuning


• Book：SQL艺术


• 书：重构SQL应用程序


• a href =http://books.google.com/books?id=1CJdgVO8PwAC&lpg=PR21&dq=database%20tuning%20principles&pg=PP1#v=onepage&q&f=false =noreferrer >书：数据库调整：原理，实验和故障排除技巧


• 使用索引，卢克！ - 开发人员数据库性能指南

• Book: SQL Performance Tuning
• Book: SQL Tuning
• Book: The Art of SQL
• Book: Refactoring SQL Applications
• Book: Database tuning: principles, experiments, and troubleshooting techniques
• Use The Index, Luke! - A Guide to database performance for developers

PostgreSQL （ wiki ）（ PGsearch ）

• 性能优化


• 快速PostgreSQL优化


• 解释分析解释器


• PostgreSQL性能提示


• 预订：PostgreSQL 9.0高性能

• Performance Optimization
• Quick PostgreSQL Optimization
• Explain Analyze Interpreter
• PostgreSQL Performance Tips
• Book: PostgreSQL 9.0 High Performance

MySQL

• MySQL的隐藏功能


• 预订：高性能MySQL / Blog：高性能MySQL


• 博客：Xaprb MySQL DBA）

• Hidden Features of MySQL
• Book: High Performance MySQL / Blog: High Performance MySQL
• Blog: Xaprb (for MySQL DBAs)

Oracle

• 如何解读查询的


• Oracle高级调试脚本 a>


• Oracle数据库性能调整指南


• 问汤姆


• Oracle数据库SQL参考


• 图书：了解Oracle性能


• 预订：优化Oracle性能


• 预订：Oracle性能问题排查


• 预订：基于成本的Oracle基础知识

• How do you interpret a query's explain plan?
• Oracle Advanced Tuning Scripts
• Oracle Database Performance Tuning Guide
• Ask Tom
• Oracle Database SQL Reference
• Book: Understanding Oracle Performance
• Book: Optimizing Oracle Performance
• Book: Troubleshooting Oracle Performance
• Book: Cost-Based Oracle Fundamentals

MS SQL Server

• SQL Server性能


• eBook：高性能SQL Server


• 问题：什么是最好的SQL Server性能优化技术？


• a href =http://www.brentozar.com/sql-server-performance-tuning/ =noreferrer> Brent Ozar的Perf优化页面


• < a href =http://www.toadworld.com/platforms/sql-server/w/wiki/9805.performance-tuning.aspx =noreferrer> SqlServerPedia的Perf调优页


• Book：Sql Server 2008 Internals


• 如何使用SQL Profiler识别缓慢查询

• SQL Server Performance
• eBook: High Performance SQL Server
• SO Question: What are the best SQL Server performance optimization techniques?
• Brent Ozar's Perf Tuning Page
• SqlServerPedia's Perf Tuning Page
• Book: Sql Server 2008 Internals
• How to Identify Slow Running Queries with SQL Profiler

Sybase SQL Anywhere

• 博客：SQL Anywhere


• 预订：SQL Anywhere Studio 9开发人员指南

• Blog: SQL Anywhere
• Book: SQL Anywhere Studio 9 Developer's Guide

JDBC

• JDBC性能提示

• JDBC Performance Tips

推荐答案

Oracle的自己的Tom Kyte有一个梦幻般的存储库，可以在 http://asktom.oracle.com 。他通常需要时间来重现特定问题，并给出非常详细的解释。

Oracle's very own Tom Kyte has a fantastic repository on every type of performance problem imaginable on http://asktom.oracle.com. He usually takes the time to recreate specific problems and gives very detailed explanations.

这篇关于有什么资源用于数据库性能调整？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！