Should non-clustered indexes be placed on separate physical device than data?

  • Grant Fritchey (9/4/2008)


    We go through the same worries about SANS all the time. You're completely dependent on your SAN admins to set up the drives appropriately and maintain them well. If your SAN admins make poor choices, you'll never know except you'll be seeing all kinds of I/O problems. However, once you get confidence that your admins are doing their jobs correctly (and believe me, that surrender of control is difficult), then everything works just fine.

    Are you sure we are not working for the same company!? :w00t:

    That's so true. It frustrates me to no end how little DBAs are consulted during the SAN design process.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • ... It frustrates me to no end how little DBAs are consulted during the SAN design process.

    Welcome to the DBA Team! 😀


    * Noel

  • Yeah, keep your hands and feet inside the vehicle at all times.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply