Post reply

OLTP vs. OLAP servers

  • September 30, 2005 at 2:55 pm

    #165506

    I've recently taken over as SQL Server DBA for a new company.  The previous DBA had convinced management that they could save money by placing ALL of the company's databases (OLTP and OLAP) on one large clustered server.   I've been explaning to them that this is not a great idea, that the cluster buys you failover by you can still run into performance issues by mixing OLTP and OLAP.  I've been asked to come of with an alternate configuration.  I have another cluster available to use.  My proposal is to split the OLTP and OLAP to the 2 separate clusters.  The question is, which cluster would best suit each database type?

     

    Cluster 1 - (4) 3GHz processors, 10GB (AWE) memory, 3 disk partitions each on separate arrays on the SAN, approx. 160GB total storage.

     

    Cluster 2 - (4) 700Mhz processors, 2GB memory, 8 disk partitions each on separate arrays on the SAN, approx. 150GB total storage.

     

    Each cluster has one HBA to the SAN storage.  I'm leaning towards putting the higher volume OLTP databases on Cluster 1, but I'd like to get other opinions as well.

     

    Thanks in advance.

  • October 1, 2005 at 4:38 am

    #594443

    I don't have a good suggestion for which server to use. However I think you might want to add 1 additional HBA to each physical server in each cluster. Part of the 'power' of a SAN is the redundancy factor. If you do not have Dual-pathed HBAs then you are suseptible to a single point of failure.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 2 posts - 1 through 1 (of 1 total)

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