Performance Monitoring

From: Stefan Wetter <swetter_at_arcor.de>
Date: Wed, 26 Sep 2007 10:41:02 +0200
Message-ID: <46fa1a86$0$4518$9b4e6d93@newsspool3.arcor-online.net>

Hello NG!

I'm pretty new to this theme. My task is, at the moment, to improve the performance of a database of one of our customers.

I monitored the database-activity with the help of some tools and find pretty much DISK-IO (read). I think that should be lower. To the same time, the buffers are only filled half.

I think i should find out, wich tables cause the physical reads (, to examine which process does need them to optimize the clients if necessary. If not, i would change the storage clauses of that tables to use another part of the buffers.)

So, my question at this time is: how can i find out which tables (or maybe indexes) cause the disk-io?

Thank you very much in advance!
Stefan Received on Wed Sep 26 2007 - 03:41:02 CDT