Home Forums SQL Server 2005 Administering Reattach database after virtualization. RE: Reattach database after virtualization.

  • April 1, 2015 at 9:14 am

    #1788054

    GilaMonster (3/30/2015)

    Cpt_Picard (3/30/2015)

    The OS can only read one data file per core.

    This is not true. Any thread on any core can issue an IO request to any file. Please DO NOT go the path of splitting a user database into a number of files = processor cores

    Thanks for the correction Gila. I'm guessing my bad memory got jumbled up from this article I read some time ago: https://technet.microsoft.com/en-us/library/ms175527(v=sql.90).aspx

    Good for me to review this again so I do not give out (or use) bad information in the future. :blush:

    I apologize for the confusion.

    brickpack, please let us know how this went / is going for you so we know if your issue is taken care of.