Re: SAME methodology questions...

drak0nian_at_yahoo.com (Paul Drake) wrote in message news:<1ac7c7b3.0306090529.5a14788c_at_posting.google.com>...

> I'd be most interested in what key tweaks this value.

This is NOT for reckless consumption, so "Gung-ho DBAs" please tune off right NOW! Usual caveats apply. Do NOT play with this if you use any of FAT32, fancy controllers and/or raw disk!!! IoPageLockLimit. Use bytes and exact numbers. Do an advanced search on google groups for this word and see for yourself. Win2K will NOT issue an I/O that is larger than this value. I use 1Mb and it seems to work well. Even though the "book" says 512K is the default, it isn't. Of course, you need the memory to play with this! M$ and all sorts of gurus tell you to not touch it. Of course you can, provided you're careful and measure and experiment sensibly. I've got a bell on the back of my mind ringing that values larger than 1Mb only work if you running ES. Can't place it, though.

An interesting side-note: you can play with ContigFileAllocation for creation of large datafiles. But this one is tricky: it applies system-wide and can cause problems if you set it more than partition's cluster size.

YMMV, IYGSDBM, etcetc.
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Mon Jun 09 2003 - 21:00:45 CDT