Forum Replies Created

Viewing 15 posts - 286 through 300 (of 1,366 total)

  • RE: Log file Growth

    GilaMonster (8/4/2016)


    GilaMonster (8/1/2016)


    A rebuild of a 10GB index will require more than 10GB of log space.

    Because there's other log records involved, and any other concurrent activities, and log reservations, and...

    Thanks...

  • RE: HeartBeat Failure

    Perry Whittle (8/3/2016)


    VastSQL (8/2/2016)


    Perry Whittle (8/2/2016)


    Then you'll have a cluster with no failover capability!

    I'd still like to know the full spec of each VM (I.e. Number of vcpus, vnics, vdisks,...

  • RE: Log file Growth

    John Mitchell-245523 (8/4/2016)


    What do you mean by "only"? What log file growth are you seeing? What other index rebuilds occur in the hour between the previous transaction log...

  • RE: Log file Growth

    GilaMonster (8/3/2016)


    The entire new index gets logged. The space does get released once the rebuild finishes, into the log file for reuse (because if that much space was required once,...

  • RE: HeartBeat Failure

    Perry Whittle (8/2/2016)


    Then you'll have a cluster with no failover capability!

    I'd still like to know the full spec of each VM (I.e. Number of vcpus, vnics, vdisks, etc)?

    Thanks Perry.

    As i...

  • RE: Log file Growth

    GilaMonster (8/1/2016)


    Yup, frequently.

    In full recovery model, index rebuilds are 'size of data' operations, which means that the entire thing gets logged. A rebuild of a 10GB index will require more...

  • RE: Log file Growth

    Eirikur Eiriksson (8/2/2016)


    VastSQL (8/2/2016)


    Eirikur Eiriksson (8/2/2016)


    VastSQL (8/2/2016)


    Eirikur Eiriksson (8/1/2016)


    VastSQL (8/1/2016)


    Hi Experts,

    Have observed that the log file is growing huge because of Index Rebuild operation? Can anyone help me understand why?

    TIA

    Have...

  • RE: Log file Growth

    Eirikur Eiriksson (8/2/2016)


    VastSQL (8/2/2016)


    Eirikur Eiriksson (8/1/2016)


    VastSQL (8/1/2016)


    Hi Experts,

    Have observed that the log file is growing huge because of Index Rebuild operation? Can anyone help me understand why?

    TIA

    Have a look at...

  • RE: Log file Growth

    TheSQLGuru (8/1/2016)


    VastSQL (8/1/2016)


    Hi Experts,

    Have observed that the log file is growing huge because of Index Rebuild operation? Can anyone help me understand why?

    TIA

    My question is how are you doing your...

  • RE: Log file Growth

    Eirikur Eiriksson (8/1/2016)


    VastSQL (8/1/2016)


    Hi Experts,

    Have observed that the log file is growing huge because of Index Rebuild operation? Can anyone help me understand why?

    TIA

    Have a look at Choosing a Recovery...

  • RE: Log file Growth

    GilaMonster (8/1/2016)


    Yup, frequently.

    In full recovery model, index rebuilds are 'size of data' operations, which means that the entire thing gets logged. A rebuild of a 10GB index will require more...

  • RE: Number of CPU cores used by SQL Server

    yujinagata72 (7/29/2016)


    Hi,

    In one of our customer, they have SQL Server licensing based on CPU cores. I was wondering how I can check how many CPU cores have been utilized...

  • RE: HeartBeat Failure

    Experts,

    We have a 3 Node cluster and if i shutdown 2 nodes of that cluster will it help in this situation?

    Thanks

  • RE: HeartBeat Failure

    Perry Whittle (7/29/2016)


    Also check for excessive co-stop waits on the esx host

    Thanks Perry.

  • RE: HeartBeat Failure

    SeniorITGuy (7/27/2016)


    VastSQL,

    For ESXi, it has to use its hardware resources to run operations just like any OS. Think of the virtual switches as a virtual appliance that needs CPU and...

Viewing 15 posts - 286 through 300 (of 1,366 total)