Forum Replies Created

Viewing 15 posts - 91 through 105 (of 110 total)

  • RE: Recommended Transaction log backup script?

    On an aside, anyone here use SQL Backup Pro? Any big advantages over native MSSQL processes?

  • RE: cluster node licensing

    I'd like to thank the previous two respondents, you are SQLRNNR and Scott, for your helpful and effective posts, you gentlemen have saved me a lot of time. Good...

  • RE: cluster node licensing

    Thanks for your input, wishing you many long years ahead with SQL Server 🙂

    Anyone have an actual resolution for my query?

  • RE: cluster node licensing

    Eirikur Eiriksson (9/23/2015)


    JaybeeSQL (9/23/2015)


    Eirikur Eiriksson (9/22/2015)


    JaybeeSQL (9/22/2015)


    Hi all,

    Does the passive node in a 2-node SQL cluster need a paid licence?

    Thanks,

    JB

    Have a look at this blog post: Microsoft SQL Server Licensing...

  • RE: cluster node licensing

    Eirikur Eiriksson (9/22/2015)


    JaybeeSQL (9/22/2015)


    Hi all,

    Does the passive node in a 2-node SQL cluster need a paid licence?

    Thanks,

    JB

    Have a look at this blog post: Microsoft SQL Server Licensing For Dummies.[/url]

    😎

    Already seen...

  • RE: Command for adding new drives?

    Hi all,

    Management want this tested - don't ask why, there's no gain except getting a baseline - but it's a Profiler trace, pre-and-post disk additions.

    Gila recently suggested...

  • RE: Command for adding new drives?

    GilaMonster (8/27/2015)


    JaybeeSQL (8/27/2015)


    Should the system databases be best moved in any particular order?

    To be honest, other than TempDB, I'd probably leave the others alone for now. Moving master is not...

  • RE: Command for adding new drives?

    GilaMonster (8/26/2015)


    That would be a far better question, because there's no SQL command to add drives to a server. 😉

    Firstly, you don't want to move the binaries, as that would...

  • RE: Command for adding new drives?

    GilaMonster (8/26/2015)


    What do you mean 'add drives'?

    We're adding drives to the database server. 🙂

    A better question is, "What is the best procedure to move database system and user...

  • RE: Prep for large increase in usage

    GilaMonster (8/9/2015)


    No, you don't need everything, however replay requires a very specific set of events and columns. Use the T-SQL Replay template and don't change anything after

    eg you need the...

  • RE: Prep for large increase in usage

    Hold it people I just had a thought (can't believe I'm so pathetic to think of such things on a Sunday morning LOL!)...

    As the purpose of the replay will be...

  • RE: Prep for large increase in usage

    GilaMonster (8/6/2015)


    Grant, who works for Redgate, recommends distributed replay. 🙂

    Replay isn't to monitor the effects of the load, it's to generate that load against a test server. You could use...

  • RE: Prep for large increase in usage

    Dupe

  • RE: Prep for large increase in usage

    GilaMonster (8/6/2015)


    Grant, who works for Redgate, recommends distributed replay. 🙂

    Hee-hee!!

    Replay isn't to monitor the effects of the load, it's to generate that load against a test server. You could use...

  • RE: Prep for large increase in usage

    GilaMonster (8/6/2015)


    JaybeeSQL (8/6/2015)


    Does Distributed Replay work similarly?

    Yes, you can use multiple controllers (from multiple client machines) to scale the workload up. You can use the Stress option of distributed replay...

Viewing 15 posts - 91 through 105 (of 110 total)