Post reply

Shrinking BPE

  • February 23, 2019 at 12:44 pm

    #77299

    Comments posted to this topic are about the item Shrinking BPE

  • February 24, 2019 at 12:22 am

    #2022754

    Good question thanks Steve, got it wrong so learned something.

    ...

  • February 24, 2019 at 9:48 pm

    #2022791

    Nice question to start the week on, thanks Steve

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • February 25, 2019 at 6:32 am

    #2022820

    hmmm - Copied this from MS DOCS

    General Remarks

    This statement doesn't require a restart of SQL Server, unless explicitly stated otherwise. If it's a SQL Server failover cluster instance, it doesn't require a restart of the SQL Server cluster resource.

  • February 25, 2019 at 7:19 am

    #2022833

    caught out by the restart as wasn't aware of it being required,
    good to know though
    ta

    ---------------------------------------------------------------------------------------
    The more you know, the more you know that you dont know

  • February 25, 2019 at 7:54 am

    #2022836

    If you read the BPE section, it requires a restart if the size is smaller than currently. If larger, it doesn't require a restart.

  • February 25, 2019 at 7:56 am

    #2022837

    (edited -- duplicate of Steve's reply)

  • February 25, 2019 at 8:07 am

    #2022840

    AH!!

Viewing 8 posts - 1 through 7 (of 7 total)

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