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