Forum Replies Created

Viewing 15 posts - 3,616 through 3,630 (of 9,253 total)

  • RE: AlwaysOn sometimes becomes out of sync

    michael.mcloughlin (1/31/2014)

    From what i read when looking into this it is suggested that a heartbeat isn't required any more from SQL 2008 onwards?

    Yes but when running the cluster validation...

    January 31, 2014 at 10:40 am

    #1685146

  • RE: AlwaysOn sometimes becomes out of sync

    HowardW (1/31/2014)

    michael.mcloughlin (1/31/2014)

    I have upped the session time-out to 15 seconds, i assume this is just a standard ping?

    Will see how it goes over the weekend.

    Careful with that, it really...

    January 31, 2014 at 6:22 am

    #1685023

  • RE: Data Directories configuration for AlwaysOn.

    Mani-584606 (1/30/2014)

    I always used to create and configure the Data Directories as below:

    Instance one on Node1:

    Instance Name: AlwaysOnAG1\INS1

    E:\SQLData\INS1

    F:\SQLLogs\INS1

    Instance two on node2:

    Instance Name: AlwaysOnAG2\INS2

    E:\SQLData\INS2

    F:\SQLLogs\INS2

    If we wanted to use Always on Availability...

    January 31, 2014 at 4:05 am

    #1684978

  • RE: SQLAgentReaderRole

    the reader role allows multi server job access over the user role, do they need this?

    The users will only be able to edit jobs\schedules that they own, what is it...

    January 31, 2014 at 3:59 am

    #1684977

  • RE: Do we need Quorum Disk or not

    DBANoobie (1/30/2014)

    I thought quorum rules indicate you need a odd number for your cluster for fail over or something like that? Then again I am still learning about Always On...

    January 30, 2014 at 7:40 pm

    #1684910

  • RE: tempdb data and log file locations

    If you can separate the tempdb log and data but always keep them separate from user data and logs.

    January 30, 2014 at 11:51 am

    #1684809

  • RE: tempdb data and log file locations

    PHXHoward (1/30/2014)

    Oh and as for sizes, server team gives us 50GB for C, and I usually request 250GB for data on D and 100GB for logs on L and 100GB...

    January 30, 2014 at 10:27 am

    #1684771

  • RE: AlwaysOn sometimes becomes out of sync

    michael.mcloughlin (1/30/2014)

    They are VM machines so the NIC are virtual (VMXNET3) which connect to a distributed virtual switch. The physical NICs on the host are 10gb Fibre which are LACP...

    January 30, 2014 at 10:25 am

    #1684769

  • RE: tempdb data and log file locations

    PHXHoward (1/30/2014)

    Building an answer file for unattended SQL Server installations. I have C:, D:, L:. and T: available.

    I was thinking of

    C: for OS

    D: for system and user data files

    L:...

    January 30, 2014 at 10:15 am

    #1684764

  • RE: AlwaysOn sometimes becomes out of sync

    what are the network connections like between nodes?

    synch or asynch mode?

    are you using a dedicated network for the mirroring traffic?

    January 30, 2014 at 4:53 am

    #1684589

  • RE: Do we need Quorum Disk or not

    TheSQLGuru (1/29/2014)

    The typical quorum for AG implementations is File Share since the vast majority of AGs are based on WSFCs that are NOT using shared storage.

    Unless one of your replicas...

    January 29, 2014 at 10:55 am

    #1684429

  • RE: Add instance of SQL Server 2012 to Cluster with SQL Server 2008R2

    Vera-428803 (1/29/2014)

    Hi all,

    I have a SQL Server cluster with 2 nodes and 5 instances of SQL Server 2008R2.

    Is it possible to add instances of SQL Server 2012 to the same...

    January 29, 2014 at 5:17 am

    #1684253

  • RE: Do we need Quorum Disk or not

    Mani-584606 (1/28/2014)

    Hi,

    We are planning to build 2 node cluster to configure Always on Availability groups.

    Do we need Quorum Disk or not? Please advise.

    If both machines are on the same site...

    January 29, 2014 at 3:39 am

    #1684217

  • RE: MULTI-Instance SQL 2008 R2 Cluster (same LUN can be shared between different Instance?)

    SSRS can make use of load balanced urls to service an instance on each cluster node. You need to create scaled out deployments of SSRS but its possible.

    Personally i...

    January 28, 2014 at 4:30 pm

    #1684097

  • RE: different user database permissions across servers

    sslyle-1091060 (1/28/2014)

    I'm looking for an efficient way to grant/block database permissions based on which server a user connects to.

    I have a development server that has a copy of a database...

    January 28, 2014 at 8:47 am

    #1683969

Viewing 15 posts - 3,616 through 3,630 (of 9,253 total)