Load test a database through unit tests RRS feed

  • General discussion

  • I want to load a simple 2-tier application i.e. a Windows client working directly against a database. So, what I would like to do is to have virtual users in a load test firing away a lot of different sql statements. 

    I stumbled across the SQL loadtest tool which is exactly what I want. It is quite old though and no updates since 2008. So, is there any better or easier way of doing this or is this still a good way to go?


    Friday, October 26, 2012 6:54 AM

All replies

  • Hi mattias,

    Thank you for posting in the MSDN forum.

    I’m not very sure what result did you want to test, maybe you could share us more information about this issue. Do you mean that you are developing a database project? If so, could you create the unit test for it? If it is related to the database unit tests like this, maybe this forum could help.

    About this SQL loadtest tool, I’m afraid that it is out of support range of this forum. To help you resolve this issue, I suggest you post a discussion here: http://sqlloadtest.codeplex.com/discussions/35896. Thanks for your understanding.

    Best Regards,

    Jack Zhai [MSFT]
    MSDN Community Support | Feedback to us

    Monday, October 29, 2012 6:19 AM
  • I want to simulate a large number of windows clients, the clients work directly against the database. So, simulating the load would in this case mean simulating database traffic.

    Since the load test tool only support HTTP/HTTPS protocol I can't capture anything using the tool. So, I thought I would just capture database traffic and use that in a unit test that later can be incorporated in a load test.

    If anyone has done something similar please let me know!

    Monday, October 29, 2012 7:01 AM