Shrinking BPE

  • Comments posted to this topic are about the item Shrinking BPE

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

    ...

  • 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”

  • 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.

  • 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

  • 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.

  • (edited -- duplicate of Steve's reply)

  • AH!!

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

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