Post reply

System pahe file and sql files

  • February 12, 2013 at 5:51 am

    #274047

    we all know that sql data files are differently read than log files (random Access , sequential Access)

    so we put them on different disks.

    The question is: when breaking the system page file into smaller files (not one big file) is with which file type to put it with .

  • February 12, 2013 at 6:13 am

    #1586973

    I would try and avoid putting it with any database files

    ---------------------------------------------------------------------

  • February 13, 2013 at 7:57 am

    #1587474

    Page file access patterns are mostly random. Think of them as an extension of physical RAM (Random Access Memory).

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply