Minaz Amin (6/11/2009)
You need to consider scaling up your processor, RAM, Netwrok Speed, Fast disk subsystem apart from DB load balancing. If number of users increase then start thinking for database load balancing, by configuring Database partitioned views , Shared server or Replication.
There isn't db load balancing in sql world 🙁