Post reply

Does Writing to a databse use the ntsf file system

  • September 11, 2007 at 10:02 am

    #174641

    This may be a really stupid question but here goes;

     

    After a database file is created, and sql server writes to a table, does the server write to the file or does sql server.  My contention is that the OS server creates the file and writes to the ntsf file allocation table for the os, but after that any internal writing to the databse file itself is handled by Sql Server.

     

    I am asking because of some resource allocation issues we are looking at.

     

    Thanks

     

  • September 11, 2007 at 10:20 am

    #732852

    SQL Server is using the OS for this. But it is highly optimized. It uses both scatter-gather (NT: ReadFileScatter and WriteFileGather) and asynchronous calls.

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • September 11, 2007 at 10:23 am

    #732853

    Thank you!

  • September 11, 2007 at 11:40 am

    #732870

    Do some poking around BOL on the "lazy writer" process, and the concept of "data pages".  should help explain a bit more about how data changes are buffered, and how those changes are committed to disk. 

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Viewing 4 posts - 1 through 4 (of 4 total)

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