September 15, 2010 at 6:41 am
Hi,
We are going to start a project in a Client Server architecture. Client will be running in Citrix on Virtual Machine, Windows 2008 configuration servers (about 200 VM). The database server will be an SQL Server 2008 R2 with about 200 databases (maximum 4 GB data each). It will be a transactional application but only with 100-200 transactions per database per day. My questions are:
1. An SQL 2008 Standard Edition with 64 GB RAM, 4 processors (8 core) would be enough as SQL Server regarding the charge? If not, to have 256 Gb of RAM we need to buy Enterprise Edition which whould be very expensive in licensing.
2. Because we need that applications run 24 h we need a DR solution that works. We want to implement something like Geo Cluster or maybe Database Mirroring. Do you know such of solutions that you allready implemented and it works in a DR architecture?
The SQL components will be on physical server and databases on a SAN.
Thank for any sugestions.
Daniel
September 15, 2010 at 7:17 am
dtipser (9/15/2010)
Hi,We are going to start a project in a Client Server architecture. Client will be running in Citrix on Virtual Machine, Windows 2008 configuration servers (about 200 VM). The database server will be an SQL Server 2008 R2 with about 200 databases (maximum 4 GB data each). It will be a transactional application but only with 100-200 transactions per database per day. My questions are:
1. An SQL 2008 Standard Edition with 64 GB RAM, 4 processors (8 core) would be enough as SQL Server regarding the charge? If not, to have 256 Gb of RAM we need to buy Enterprise Edition which whould be very expensive in licensing.
2. Because we need that applications run 24 h we need a DR solution that works. We want to implement something like Geo Cluster or maybe Database Mirroring. Do you know such of solutions that you allready implemented and it works in a DR architecture?
The SQL components will be on physical server and databases on a SAN.
In terms of load you specify 64GB RAM and 32 processors will be ample. Are you suer about 8 core, do they make those yet? A couple of Quad cores should be ample.
As for DR with that number of databases I would not go for DR at the database level due to the support overheads, so database mirroring and logshipping are out. that does leave you with a geo-cluster (or multi-site clustering as MS call it), or if this install is the SQL engine only two standalone servers, using SAN mirroring of the user databases only would work, just a slower failover.
We run both set ups successfully.
---------------------------------------------------------------------
September 15, 2010 at 8:22 am
Thanks for your answer. It is possible to have a MSSQL Cluster on Windows 2008 R2 with two physical server for SQL Server 2008 R2 (Standard Edition) and SAN mirroring? The DR site would be an external site with one of the SQL server and with another SAN in mirror. Is there somewhere any documentation that explain this architecture? We allready have a SQL 2008 Cluster with DB's on a SAN but all are in the same location.
Another question. Our application open a lot of connections to each database on SQL Server (could be more than simultaneus 32000 connections on SQL server). Could this pose a problem with max number of user connections at the same time allowed in SQL Server? I know that this is 32767 connections (SELECT @@MAX_CONNECTIONS) but the SQL Server has set as unlimited connections in the server properties. What's the difference between this two properties?
September 15, 2010 at 8:56 am
In terms of software versions the only pre-req is windows 2008
See also http://technet.microsoft.com/en-us/library/dd197575(WS.10).aspx
and google for this white paper 'SQL Server 2008 Failover Clustering'
Max connections set to 0 means use the max possible, i.e. its the same as setting to 32767.
I suggest you look at connection pooling.
---------------------------------------------------------------------
September 15, 2010 at 9:03 am
I would also suggest you engage someone that has done this. If you are going for a really large scale installation, Microsoft Consulting Services, or the SQL CAT team could review things for a relatively low cost and help you ensure things are configured well.
September 15, 2010 at 10:08 am
Thanks for your advices. I found some articles that explained how to do a Multi-Site Cluster, for sure we need external help.
Regarding the connections pooling the applications don't use ADO.NET so we can't use this feature. So maximum simultaneus connections is 32767 in SQL 2008. How SQL 2008 could be used for a Web based application if you limit your connections at maximum 32767? I just thinking about.
Thanks again.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply