Re: db_Writer performance

Using statspack, take a snapshot every 10 minutes for a few days. Start comparing the statspack values from the report over the smaller time frames too see if there are actually waits, or the database is just always writing.

You will be able to identify the statements causing the writes and tune them, you will be able to find the datafiles that are being written too and move them around or move the objects around if the DB is hot blocking on a group of disk spindles.

We have a database that spends its entire life writing to disk because it simply is fed data 24 hours a day as fast as it can accept it, then it has to clean up the old stuff while dealing with the new stuff. almost all it does is write. 94% of all operations in the database is writes.
But it isn't in need of any tuning.

Look on the manuals for statspack. Received on Wed Mar 08 2006 - 08:11:34 CST