Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DavidAnderson
Starting Member
3 Posts |
 Posted - 2008-04-23 : 19:20:55
|
| Hi all, we are thinking about moving to a iSCSI SAN for our SQL and Exchange processes and I was hoping to get some advice on how the features of 2005 or sQL 2008 will allow us to have the highest availability while using the best amount of resources.We're currently running:SQL 2000One server holds three live databasesthe other 3 servers are currently setup as readonly'sWe also have a Netscreen load balancer that balances the readonlys.My question is:If we upgrade to SQL 2005 and have a SAN, is it possible to cluster the 4 servers together for data pulling from the SAN, or do I still have to have a single "live" server that processes all the inserts and updates?Tnx. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-23 : 19:24:07
|
| Yes you can cluster servers together if they share a SAN. I don't understand your question about the live server and processing inserts/updates.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
DavidAnderson
Starting Member
3 Posts |
Posted - 2008-04-23 : 19:28:52
|
| From our front end (ColdFusion), we have to select a DSN for the SQL server that it should be using for the SQL Inserts/Updates. In the case of the SAN, does it matter which server is doing the inserts? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-23 : 19:32:45
|
| Using a SAN does not change how you have things setup.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
DavidAnderson
Starting Member
3 Posts |
Posted - 2008-04-24 : 00:34:12
|
| Cool, thanks! If you have any experience with SAN setups on SQL and are interested in consulting, i'd love to hear from you. You can email me directly at david.anderson@americasvacationcenter.com.Thanks Tara, David |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-24 : 21:39:19
|
| Quest tested sql server disk i/o on SAN and sql server magazine published results, check their web site. |
|
|
|
|
|
|
sql 2005 - SAN Architecture