The Oracle parameter db_file_multiblock_read_count, often shorted “MBRC”, is a mighty one. If set to the wrong value your database may suffer from bad I/O. It’s up to you to test and find the right value for it.
Tag Archives: Performance
I just bought a FireWire 800 disk from LaCie and intend to use it for my virtual machines. I did a simple performance test as this is my first FireWire disk:
Yesterday I had to help a customer with very bad query performance of their SQL Server 2008 with a 1-terabyte datawarehouse. I found that tempdb filled up the C: drive and was not layouted correctly. As recommended by Microsoft you … Continue reading