Doru wrote:
>Do you happen to know methods to approach the problem of testing the
>capacity of an application to work with an SQL database?
>
>In particular, I am interested in simulating concurrent requests
>towards this database that would resemble the interaction coming from
>the application.
I once created a simple model for a distributed ram-based OLAP system.
That had independent nodes, connected to a network with known delay and
speed, and simple read-only queries. Queries would just take some space,
move (and split-join) from node to node and increase their timestamps.
For a sql database just start adding complex queries, write locks,
limited buffer sizes, cpu cores & caching and disks...
Not so easy.
Stephan