Scalability issues & Corrective measures .....

Folks

From a presentation to Management Perspective need the following:-

What are the limiting factors to scalability from the Database perspective & how can they be addressed?

Some Examples:-

Data model (e.g. inappropriate Driving table or index, Large tables that are not partitioned)
architecture (e.g. inappropriate design)

Additionally What are the limiting factors to scalability from an Application perspective & how they can be addressed?

Some Examples:-

Architecture
Constraints of the development toolset
Inefficient usage of Machine resources by Batch Jobs
Inability to stream parts of a batch job
Common application service causing a bottleneck
Network traffic between app and DB server

NOTE – Ours is a Banking Product (Hybrid nature of Transactions)

Cheers

**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***

Scalability issues & Corrective measures ...........presentation to Management

VIVEK_SHARMA

2007-06-11