Forum Replies Created

Viewing 15 posts - 5,551 through 5,565 (of 9,253 total)

  • RE: 2 node cluster Split-Brain Issue

    So your attaching the LUN and creating an ESX data store and then creating VMware virtual disks for sharing amongst the VMs?

  • RE: measure PAE using or not?

    ananda.murugesan (5/23/2012)


    Please confirm the options which is correct boot.ini file modification.

    Option -2

    boot loader]

    timeout=5

    default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS

    [operating systems]

    multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /fastdetect /3GB

    Option 2 initially, but bear in mind that not specifying /noexecute=optout...

  • RE: 2 node cluster Split-Brain Issue

    sbaker-757360 (5/23/2012)


    I have not seen any current ESXi v5 or Microsoft 2008 R2 MSCS documentation saying that our configuration is not supported (as log as our IBM SAN supports PR).

    Our...

  • RE: 2 node cluster Split-Brain Issue

    sbaker-757360 (5/22/2012)


    shared disks (SCSI bus sharing set to Physical)

    This type of shared drive is not supported for Windows 2008 it will only work with Windows 2003 nodes. Hence why...

  • RE: Best procedure to introduce clustering in a high OLTP environment

    deep_kkumar (5/22/2012)


    Are you able to re-point the applications etc? YES

    I will try to work on the mirroring option.

    Can I know more about other options?

    you could also log ship the databases...

  • RE: 2 node cluster Split-Brain Issue

    Are both VMs on the same host (Cluster in a box) or are they on separate hosts?

    Is this a host based vswitch or a distributed vswitch?

    How is the storage presented...

  • RE: measure PAE using or not?

    ananda.murugesan (5/22/2012)


    OS - Win 2003 Enterprise Edition

    Database - SQL 2008 Enterprise Edition

    Memory - 4GB

    please tell me, how to measure /PAE really using or not after configured as below boot.ini...

  • RE: SQL 2012 High Availibility

    derekr 43208 (5/21/2012)


    Is the below possible?

    2 Servers part of the Same Windows Cluster

    SQL Server installed as Clustered Instances on both Nodes

    Seperate Storage

    Would this configuration allow for Availibility Groups(Database Level Protection)...

  • RE: SQL 2012 High Availibility

    derekr 43208 (5/21/2012)


    This is where I am a bit confused....

    For AG's, all nodes must be part of the same cluster but with seperate storage?

    For HA Instances all nodes must be...

  • RE: SQL 2012 High Availibility

    This is already detailed in my previous replies, but

    derekr 43208 (5/21/2012)


    does each node need to be part of the same cluster?

    For availability groups, yes, all nodes need to be part...

  • RE: Cluster Installation

    This seems to have veered drastically from your original request. Your production servers are virtual machines are they?

    You could start by answering my questions and reading the link I posted...

  • RE: How to use SQLIO for Mount points on cluster

    madhu-686862 (5/16/2012)


    How to use SQLIO for Mount points on cluster to test the IO on SAN?

    Have you read the documentation for SQLIO? Also check the SQL server storage best practices...

  • RE: Cluster Installation

    deep_kkumar (5/16/2012)


    1) How much space I need to allocate for quorum drive?

    512MB

    deep_kkumar (5/16/2012)


    2) shared disk space depends on the database sizes.

    How much do you think you will need??

    Will you be...

  • RE: sa_help_rev.erse.sa.login

    Sure, here you go

    SELECT 'CREATE LOGIN ' + name +

    ' WITH PASSWORD = ' + sys.fn_varbintohexstr(password_hash) +

    ' HASHED, SID = ' +...

  • RE: Shrinking data files for similar database names

    Norm-677551 (5/14/2012)


    from

    ?.dbo.sysfiles a

    ) x

    where [free_space_mb]/[file_size_mb]*100>50

    and NAME like ''wslogdb70_%'''

    ...

    Am I right?

    if you're going to use system catalogs at least use the right one. For file info at database level...

Viewing 15 posts - 5,551 through 5,565 (of 9,253 total)