• Elliott Whitlow (7/9/2013)


    Keep in mind I have only a bit of experience with SSDs. But my understanding and experience is that random access and sequential access are virtually the same on an SSD because we don't have to even consider waiting for the platter to come around. Depending on how many drives you are working with there is usually some benefit to having more channels of access to the drives. If we are only talking about 4 drives then I would probably just break it down to logical drives.

    I'd google: sql ssd best practices

    And this URL looks promising: http://www.sqlservercentral.com/blogs/hugo/2011/06/08/notes-from-solid-state-for-sql-server-with-wes-brown-from-today-s-idera-broadcast-ssd-best-practices-for-database-servers/[/url]

    CEWII

    Thanks for the information, I will pass it on and check out the link.

    Tracie