Tags » Database Tuning

Reading AWR Report - Part 1

Once in a while I get requests for some information about reading and analyzing an AWR report. I have been thinking for a long time about writing such a post, but always postponed it as it is a very tricky topic. 822 more words

Infrastructure

Machine learning for database tuning: Mobiliar’s journey continues. Next stop Munich.

During the first week in May, I could share Mobiliar’s experience with the practical use of machine learning technology for DB2 systems tuning at IDUG’s annual North American DB2 Technical conference in Anaheim, CA. 529 more words

DB2

Optimizer Bugs and Issues

I wrote before about optimizer changes after upgrades, so this is a quick post about some more information related to this topic. 213 more words

Database Tuning

Scanning an Index

The internet is full of information about indexes, and for a reason. Indexes in a database is probably the most important performance related topic. There are so many cases, properties, and different ways to use indexes that there is simply a lot to write about. 1,419 more words

Database Development

05 Simple Tuning Rules

Select Consideration


select * from sales_history

versus

Select s.order_ID, s.product_ID, s.price, s.product_name

from sales_order s

The simplest rule is to select only the data you need… 292 more words

Verbat

Indexing Tool : Database Engine Tuning Advisor

Related article : Indexing Tools for Microsoft SQL Server (You might want to read the article before this one to get a better picture)

The other indexing tool available in… 4,609 more words

Verbat

Indexing Tool : Missing Index Dynamic Management Objects (DMO)

Indexing Tools

When it comes to indexing, Microsoft has two tools built into SQL Server that can be used to help identify indexes that can improve database performance. 3,074 more words

Verbat