Unanswered: database performance very bad, any advice?
check cpu, harddisk queue, read & write, memory usage, all very normal.
but one purticular database is very slow( all others are normal). it took 10 seconds to insert one record into the slow database. each record is less than 300 byte, all varchar. now there are 1 million records in the core table.
use DBCC showcontig to check the slow db, found out this: