Forum Replies Created

Viewing 15 posts - 3,481 through 3,495 (of 9,253 total)

  • RE: Upgrade using db mirroring

    Oracle_91 (3/12/2014)


    Hi Everyone,

    I came to know that using SQL Server database mirroring, we can perform the upgrades with minimal downtime.

    How that is possible? Can anyone elaborate ?

    I...

  • RE: AG Failover Order

    PHXHoward (3/11/2014)


    We hoped to have a failover priority order. Three synchronous replicas. One secondary locally and one in the other datacenter so that if the primary replica server fails, it...

  • RE: SQL Server 2012 Clustering Questions

    sellers.rick (3/12/2014)


    The current cluster is a pair of Dell servers (not sure of the model number) with Intel Xeon CPU E7-4830 @ 2.13 Ghz (32 cores), 128 GB RAM mirrored...

  • RE: Always on availablity group

    Martin Stephenson (3/12/2014)


    Perry Whittle (3/12/2014)


    Martin Stephenson (3/10/2014)


    test2 is the automatic failover synchronous non readable

    The readable secondary is not important at this time, what are the connection settings when in the...

  • RE: Always on availablity group

    You maybe need to read my 4 article on FCI and AO.

    Parts 1[/url] and 2[/url] have been published, 3 and 4 will follow soon

  • RE: SQL Server 2012 Clustering Questions

    sellers.rick (3/11/2014)


    1. Is it better to build a separate SQL Server 2012 cluster with the two new nodes? My understanding at this time is the answer to this question...

  • RE: Always on availablity group

    Martin Stephenson (3/12/2014)


    Yes I am scrambling my terminology - High availability uses clustering serivices but isnt a cluster apologies for mangling my terms.

    So by using the listener as the...

  • RE: AG Failover Order

    PHXHoward (3/11/2014)


    We hoped to have a failover priority order. Three synchronous replicas. One secondary locally and one in the other datacenter so that if the primary replica server fails, it...

  • RE: Always on availablity group

    Martin Stephenson (3/10/2014)


    test2 is the automatic failover synchronous non readable

    The readable secondary is not important at this time, what are the connection settings when in the primary role for test2,...

  • RE: Always on availablity group

    Martin Stephenson (3/12/2014)


    Because I simulated a failure by closing down the test1 server, the sql HA cluster failed over to test2 as expected

    You don't have a sql a cluster you...

  • RE: Always on availablity group

    You shouldnt need to touch the cluster configuration, i'm assuming you mean that you have removed cluster votes from some of the nodes?

  • RE: how service sids are used ?

    Oracle_91 (3/8/2014)


    Hi Everyone,

    This question is out of curiosity and it left me in confusion whether service account as any role to play in sql server startup and shutdown?

    Can anybody explain...

  • RE: cluster failover --memory

    muthyala_51 (3/11/2014)


    500 GB RAM

    Bit of an odd figure, i'm assuming that's 512GB RAM?

    muthyala_51 (3/11/2014)


    425 GB max memory setting.

    Given the fact you have a lot of CLR and ext stored proc,...

  • RE: cluster failover --memory

    How physical do you have and what is max server mem set to?

  • RE: cluster failover --memory

    muthyala_51 (3/8/2014)


    any suggestions?

    For what?

    anything now would just be speculation since the instance was restarted

Viewing 15 posts - 3,481 through 3,495 (of 9,253 total)