I work on a web based application where a user will be able to create a databse fo himself online.
The size of the database that the user creates varies and there are 3 available servers.
How do I know where to direct this user.I am thinking of putting in the performance statistics in a database for each of these servers and update it frequently and the front end can query this database to determine where they have to direct the incoming request for a new database.
Will this approach work?If it does what is the information that I need to put in this table which the font end can query about the performance?
How can I do that?Is there an option in the performance monitor to send the info of the counters to a table?Should this be done through the profiler?
Any help regarding this matter is appreciated.
I have to provide this information to the front end java guys so that they can create objects and components o make use of this information.

regards
Sushruth Nanduri.