Post reply

GUI Enhancement on Instant File Initialization (IFI) in SQL Server 201

  • May 3, 2016 at 12:02 am

    #310327

    Comments posted to this topic are about the item GUI Enhancement on Instant File Initialization (IFI) in SQL Server 201

  • May 3, 2016 at 6:30 am

    #1876187

    Good article. Quick question:

    If you don't enable during installation, do you have to follow the same steps as in prior versions?

    Thanks.

    Miguel

  • May 3, 2016 at 6:47 am

    #1876194

    Thanks for the article.

  • May 3, 2016 at 7:30 am

    #1876228

    Thanks! Prior to SQL Server 2016 (CTP 3.0), if you want to enable this feature, you have to follow below mentioned steps;

    Open the Local Security Policy application.

    Expand Local Policies, click on User Rights Assignment.

    Now double click on “Perform Volume Maintenance Tasks”.

    Go to Add User or Group and add Service Account.

    Click on Apply

    Thanks - Dharmendra!

  • May 3, 2016 at 7:30 am

    #1876229

    Thanks!

  • May 3, 2016 at 7:45 am

    #1876239

    Thanks!

    By the way, what are the risks?

  • May 3, 2016 at 9:59 pm

    #1876482

    Hommer (5/3/2016)

    Thanks!

    By the way, what are the risks?

    There are two.

    The first is that you've just given the SQL Server login more privs.

    The second is that old data isn't removed from the space assigned until it's over written by new data and someone good (as in bad) could get at it. Of course, that's also true just about everywhere else, as well. The "normal" thing that takes so long is that the new space allocated is zeroed out. Note that for DOD and other high security systems, even zeroing out the data on the disk once isn't enough.

    For the kind of work I do, neither is considered a problem but that may not be the case for the kind of work you do. I wouldn't just assume. Get written consensus.

    --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)

  • May 4, 2016 at 5:05 am

    #1876526

    Do you have the snippet of the script that will enable this feature?

    412-977-3526 call/text

  • May 4, 2016 at 7:15 pm

    #1876749

    If you were installing this as a local admin and this policy was set at the domain level, could IFI still be turned on in this way? I suspect it wouldn't. And, if it can't, what effect does this have on the installation? Hopefully, it would be smart enough to carry on with the installation and provide a warning in the installation logs.

  • May 5, 2016 at 5:37 am

    #1876796

    Great. I typically have our Security Admin team do this before I install SQL Server. However, sometimes I wonder if they actually do this or not all of the time. 🙂

Viewing 10 posts - 1 through 9 (of 9 total)

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