P
Paul Koufalis
Guest
Remove it. It is unlikely doing any good. On Tuesday in my presentation on DB startup parameters I said that there was no more need for -directio. Dan Foreman corrected me: he found a particular case under Solaris with a less-than-optimal disk I/O subsystem where -directio was helpful. If you could describe the issues we can try to help. Turning on PerfMon recording for 24h is also a good idea. You may see something that stands out during the perf issues. I had a similar issue a couple of months ago and it turned out to be Windows losing its mind (again). SYS CPU% would jump up to 50-60% for no reason for extended periods.
Continue reading...
Continue reading...