Forum Replies Created

Viewing 8 posts - 31 through 38 (of 38 total)

  • RE: An alternative to GUIDs

    One of the mottos that has served me well over the years is "Don't code a solution to an infrastructure problem when an infrastructure solution exists".

    To cope with failover, there...

  • RE: Solid State Disks and SQL Server

    This is the reply I received from my contact at Fusion IO

    "The sector size can be changed between 512(default) and 4k (4096) (not 8k). I think this is only supported...

  • RE: Solid State Disks and SQL Server

    I've sent an email to my contact at Fusion IO - hopefully we'll get some definitive answers on sector size in relation to their cards

  • RE: Solid State Disks and SQL Server

    Firstly, as an aside, you don't have to worry about the offset with Windows Server 2008 and Windows 7 onwards - basic disks on these versions default to a 1MB...

  • RE: Solid State Disks and SQL Server

    I was talking about the cluster size for formatting. However, as I understand it, currently most drives physical cluster size are 512 bytes with some new drives at 4096 supported...

  • RE: Solid State Disks and SQL Server

    Look at the price of a regular SAN with regular disks. It still can't compete on price! I did a price/performance comparison of a single MSA70 (25 disks) to an...

  • RE: Solid State Disks and SQL Server

    A solid state SAN won't come close - maximum bandwidth per slot is 4Gbps (500MB/s). Plus you have the added latency from the fabric switches, etc. But the real SAN-SSD...

  • RE: Solid State Disks and SQL Server

    I'm surprised you didn't set the sector size to 8KB. That's the page size for SQL Server and would have been a better choice than 4KB.

    On my production servers, I...

Viewing 8 posts - 31 through 38 (of 38 total)