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 |
|
louigom2
Starting Member
1 Post |
 Posted - 2008-12-12 : 17:26:07
|
| Hi all,We currently have a SQL 2005 server that runs our Ecommerce application. We are a very high transaction volume shop in regards to retail orders.We are in the process of implementing SAP and this system will interface with the current ecomm server - modifying and deleting records on this web server. We are talking about a range of 7K to 500K rows being updated and purged throughout the day. I am already anticipating a performance hit on our web server that might cause timeouts for our users.Do you have any alternative SQL architecture solution for this one?Any help would be greatly appreciated. Thank you very much. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-12-12 : 17:31:52
|
| We don't have enough information to be able to recommend anything to you. 7k to 500k rows being updated and purged each day isn't a big system. Timeouts shouldn't be an issue on the web server if you are properly designed with hardware, database, and application code, and queries. How big is the database expected to be in the next few months to a year? How many concurrent users will you have? How many transactions per second? What are the performance expectations?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
Website Performance