Post reply

Diskallignment questions ?

  • November 15, 2019 at 10:09 am

    #3697971

    In the old days blocksize and disk allignment was important for the performance.

    For SQL2017 on a VM machine is this still an 'issue' ?

    I haven't encountered this for years, so I think this is a thing of the past ..... Great question mark ....

    Things like virtual mapping of disks, San's, SSD's with again a sort of virtual mapping, raid systems haven't they made these concepts obsolete or maybe to complex ?

    Thanks for your time and attention,

    Greetings,

    Ben

     

     

  • November 16, 2019 at 10:10 am

    #3698251

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • November 16, 2019 at 2:43 pm

    #3698271

    It is an alleged non-problem any more.  I say "alleged" because I trust no one on such things (too many times burnt in the past).  There is a simple test to determine if it's a problem and I'll be damned if I can put my hands on the code today.  I'd have to a Yabingooglehooduck for it (again) so you might give that a try first.

     

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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