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 |
|
NickyJ
Starting Member
46 Posts |
 Posted - 2005-07-19 : 04:49:53
|
Question : I have recently been thrown in at the deep end and am taking on SQL duties so hopeful many of you out there will be able to help me with my questions and assistance will be greatly appreciated.I have a system which is used across various countries from the UK to the US and many throughout Europe (Germany, France etc…) Now every system is the same except that for each system in each country there is a separate server and database due to timezones and currency factors.So everytime the system is rolled out to a new country then a new server is purchased. The application uses Web asp pages for the front end, sending dynamic T-SQL statements (no SPs at all) and a separate server is bought everytime for IIS.Currently I have 1 UK SQL Server, 1 IIS UK Server1 US SQL Server, 1 IIS US ServerNow this continues to the point that now have 5 SQL Servers and 5 IIS Servers the databases are the same as in tables, procs, views, etc however the server time is obviously reflectant upon the country system is running in and then there’s the currency issue.My task is to come up with ways to consolidate, with reasoning behind it.Questions : Can IIS and SQL Server run okay on the same box ?? Disadvantages ??As you can guess, for 4 systems right now we have to maintain 4 IIS boxes, 4 SQL boxes and 4 different databases.I was thinking the database could have a control table which handled the timezone, currency fluctuation etc… then it could sit on one SQL Server, then I need advice on whether IIS can be on the same server or not ???Currently the Server installs all vary some SQL 7.0 and some SQL 2000, always Standard Edition and I can’t see from what I’ve read why Enterprise Edition would be required, memory varies from 512Mb to 2Gb. Some of the servers have Backup software on them and some don’t.I’ve read before about Database design and have noted that the systems need redesigning as all the data, log and backup files for all databases (including tempdb) go to the same drive on RAID 5 array which I realise is not ideal. Currently one server has 2Gb and the Db is 1.3Gb so I assume SQL handles this in Cache as it’s got enough memory to do so ???Am open to suggestions and would appreciate peoples input.  N |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-07-19 : 07:51:12
|
| "Can IIS and SQL Server run okay on the same box"We have some clients who run that way, and some who have IIS and SQL on separate boxes. The second lot runs MUCH faster.Until you reach maximum load/resource utilisation I would have thought multiple databases and multiple web sites on [two] single box is the way to go.Programming either Web site or Database to be dependant on the Locale of the O/S sounds daft IMHO.Kristen |
 |
|
|
|
|
|
|
|
My SQL Environment