Forum Replies Created

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

  • 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" 😉

  • RE: TDE and SQL Server Databases

    Hi Todd thanks for the comments, I totally agree, if you're serious about implementing TDE then an external key management service is a must.

    The 3rd party products I referred to...

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

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

  • RE: TDE and SQL Server Databases

    yes i can see that would be a little embarrassing, 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: TDE and SQL Server Databases

    guy.stephens (8/16/2012)


    I'm surprised there isn't more mention generally about the fact that TDE is only available in SQL Enterprise edition.

    This seems to be where it is least needed as the...

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

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

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