I have made an application using Microsoft ASP.NET and an MS-SQL DB through NHibernate ORM for a client and the DevOps department has asked me the following question:
“Do you have any tests which tells how fast a database we need to handle the load of 10/100/1.000/10.000/100.000 users etc so we can scale it accordingly?”
Has anyone attempted this or has some experience with it?
The solution I am considering is to write an integration test that would simulate a set of queries that a standard user would execute against the application. Measure the performance using NHibernateProfiler. Then execute that standard user test 10/100/1000 amount of times while keeping track of the Profiler results.