Forum Replies Created

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

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

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    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?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    January 28, 2014 at 8:47 am

    #1683969

  • RE: Cluster not failing over after adding physical disk

    jayoub (1/27/2014)

    Still no luck. I rebooted the server and tried the move and it was the same results.

    I still feel like the SAN Admin has not provisoned...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    January 28, 2014 at 8:02 am

    #1683933

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

    fasttrack2 (1/28/2014)

    1) In a Multi-Instance Cluster:What About for the SQL Instances Installations? (locally? On external Storage? On external Storage on same LUN)

    The binaries will be installed locally as will shared...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    January 28, 2014 at 6:57 am

    #1683895

  • RE: Combining AlwaysOn Groups With Failover Cluster Instances

    Hikmer (1/27/2014)

    what I am lacking is a guide to combine Fail-over Clustering with AlwaysOn Availability.

    I have a guide being published soon on SSC showing how to achieve this,...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    January 28, 2014 at 12:29 am

    #1683807

  • RE: Combining AlwaysOn Groups With Failover Cluster Instances

    Hikmer (1/27/2014)

    Thanks fro this article, but you don't actually say HOW to do this...I want to setup an AO group for an existing failover cluster and it isn't clear which...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    January 27, 2014 at 7:27 pm

    #1683774

  • RE: Proper Way To Add Different Subnet Node to existing WSFC with FCI instances

    The issue is most likely to be that the cluster wizard is automatically adding the new nodes local storage as cluster resources. Been a while but if I remember correctly...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    January 27, 2014 at 3:24 pm

    #1683737

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