Re: Installing SQL to a SAN

From: Danny (istdrs_at_flash.net)
Date: 11/20/04

  • Next message: Fany Vargas [MSFT]: "Re: How to install service pack 3a on a failover cluster"
    Date: Sat, 20 Nov 2004 02:39:29 GMT
    
    

    James,

    Just like traditional SCSI, attaching a server to a SAN requires a
    controller. Once installed and the SAN is configured you will see one or
    more additional drive letters (a few administrators use mount points but
    usually in very large implementations). Before you attach, discuss your
    requirements with the SAN administrator.

    How much disk do you need for data?
    What will the RAID configuration be?
    How much for logs?
    How much for backups?
    Will the SAN be used for SQL backups or mirror splits?
    How much for tempdb and so on...

    You can keep spreading the activities out with more files, filegroups, and
    drives.

    Good luck,
    Danny

    "James" <hushdontspamme@Hotmail.com> wrote in message
    news:ebTQvZjzEHA.1300@TK2MSFTNGP14.phx.gbl...
    > Hi
    >
    > We have a client that wants to implement a SAN to be shared by other
    > servers.
    >
    > How do you setup a SQL server to use the SAN array? The client only has
    > one SQL server (node).
    >
    > I have implemented SQL onto Active/Active and Active/Passive clustering
    > before, but i am confuse to just how to install single SQL node to a SAN
    > array (i.e no failover)
    >
    > Can anyone give me some pointers please
    >
    > Regards
    >
    > James
    >


  • Next message: Fany Vargas [MSFT]: "Re: How to install service pack 3a on a failover cluster"

    Relevant Pages

    • Re: Add new cluster and use existing LUNs?
      ... > Even a SAN has a maximum I/O capacity. ... you can share a LUN with more than one server. ... > Microsoft SQL Server MVP ... >> The first 5 drives of our SAN share the system binaries, ...
      (microsoft.public.sqlserver.clustering)
    • RE: Storage server
      ... pretty firmly in the SAN neighborhood. ... With a server, you are constricted by the speed and design of your network. ... This means if you don't have very good switches, the correct QoS, and low ... Whereas if we use a storage server, we can easiliy upgrade the system ...
      (microsoft.public.windows.server.general)
    • Re: Multi-Channel Raid VS SAN Storage
      ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
      (microsoft.public.sqlserver.setup)
    • Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
      ... I have had quite a number of clients that used a SAN for a database server and suffered significant performance problems because their underlying SAN infrastructure was a huge stripe across many drives. ... By application files I mean the binn folder which contains the sql server executable among other things. ...
      (microsoft.public.sqlserver.setup)
    • Re: Multi-Channel Raid VS SAN Storage
      ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
      (microsoft.public.sqlserver.setup)