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.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Simple load question

Author  Topic 

rainhead0101
Starting Member

3 Posts

Posted - 2010-03-12 : 11:28:47
Hi - I have a small web app that's a simple web form populating a 7-column sql db by calling a sproc. That's it - only writes, nothing else except for a weekly, one-time count() query. If this Web site is going to get, potentially, several thousand users hitting it in a very short amount of time (even all at once), can sql 2005 handle that many inserts happening all at once? Or do I need to take any high-availability steps? Thanks for helping a noob who's trying to do the right thing!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-12 : 18:34:53
SQ/l 2005 can handle it, but maybe your hardware can't. Can your disks support it?

High availability doesn't necessarily mean better performance.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -