How to/ideas? - Unit/performance testing

• NicHopper

  SSCrazy Eights

  Points: 9090

  More actions

  May 13, 2019 at 7:42 am

  #3641329

  Hi,

  I wondered if someone could offer some insight in to methods of testing database releases, namely these fall in 2 categories.

  1. Function - I've seen testing of functions done with Visual Studio unit tests and these seem to for most scenarios but is it the best way to test functionality changes to a database project?
  2. Performance - It gets tricky here, what I'm trying to identify is that procedure A used to take 2 seconds and now it takes 1 minute because of that new function you added. I know a whole heap of factors can play a role in this but putting them aside for now and saying its done on the exact same server at the same time of day with the same workload etc. Has anyone got a method of doing this in a repeatable manner? Distributed Replay controller perhaps?

  Any and all ideas and comments are welcome.

  Thanks,

  Nic

  Check out my blog http://www.sqlservercentral.com/articles/Best+Practices/61537/

• david.Parsons 36778

  Say Hey Kid

  Points: 666

  More actions

  May 15, 2019 at 10:15 am

  #3642279

  Hi,

   

  I would recommend tSQLt for unit testing database functionality