Forum Replies Created

Viewing 15 posts - 5,146 through 5,160 (of 9,244 total)

  • RE: Moving tempDB from RAID10 to RAID5 for OLTP?

    Jeff Moden (8/22/2012)


    I guess a question on my mind at this point is why anyone would need a 200GB TempDB.

    That would be my first question

    Evil Kraig F (8/22/2012)To the vendor's...

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

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

  • RE: AlwaysOn Availability Groups in SQL Server 2012

    Lol you are way to kind, once again thank you.

    Btw keep an eye out for my article detailing how to combine failover cluster instances of SQL server with AlwaysOn availability...

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

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

  • RE: AlwaysOn Availability Groups in SQL Server 2012

    Thanks for the feedback, please don't forget to rate the article if you found it useful 🙂

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

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

  • RE: How do i connect cluster instance??

    Above you specify instance name as heartbeat!

    Is this a default or named instance of SQL server?

    Confirm the SQL server config manager settings and post them back

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

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

  • RE: choosing HA SQL 2008 R2 64bit?

    ananda.murugesan (8/21/2012)


    and we have 100mbs n/w speed. Is it sufficent for data tranfer to mirror server.

    This would quite possibly struggle to meet the needs for the public network access let...

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

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

  • RE: How do i connect cluster instance??

    what value did you provide for the network name?

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

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

  • RE: SSD storage performance increase

    Sure, you can RAID SSDs but you'll be doing it for the redundancy capabilities more than anything as the performance is already high as a result of the SSDs ultra...

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

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

  • RE: Dual server setup question

    anders 54226 (8/21/2012)


    I really cant see how san will give me overhead compared to Local attached disk with 15 K RPM. With SAN with autotiering i can get alot...

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

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

  • RE: Dual server setup question

    anders 54226 (8/21/2012)


    Since this sql will probably host some large dbs, we would probably need to use SAN disk

    Has absolutely nothing to do with using a SAN, you can still...

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

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

  • RE: Dual server setup question

    anders 54226 (8/20/2012)


    I'm looking to setup a new sql2012 environment where several dbservers will be consolidated. I wondering what the best setup will be when i got two ...

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

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

  • RE: SSD storage performance increase

    Just goes to show how performance is actually available. I'm sure there would still be increased latency if it were an iSCSI datastore, you have so much more in between...

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

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

  • RE: SSD storage performance increase

    Scott D. Jacobson (8/20/2012)


    Care to give any more information on the datastore? RAID level, HBAs, interconnects? Also, specifically what make and model of SSDs here? I'd think you're using something...

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

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

  • RE: SSD storage performance increase

    Grant Fritchey (8/20/2012)


    It is amazingly faster. It's just not the same at all.

    it's great 🙂

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

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

  • RE: Adding 2nd Transaction Log File to Mirrored Database

    both instances on the same VM?

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

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

  • RE: Netapp snap for files, log shipping for database?

    NetApp snapmanager (which incidentally I am not keen on at all) is implemented at the storage level. Native SQL backups or backups using a 3rd party tool such as Redgate...

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

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

Viewing 15 posts - 5,146 through 5,160 (of 9,244 total)