Release Management utilities for RM 2015


Recently one of the customer wanted to know whether we have any utilities/best practices document that he can follow while managing his release management installation. Abhishek Aggarwal/Madhu Vadlapudi/me put together some of the utilities that we had, that were relevant for this customer, and I am sharing them with you below.

  • Find the releases which can be abandoned and abandon them. The script is here.
  • Find out how much load windows workflow layer is putting on the system and reduce the load it by cleaning up the workflow tables as sometimes abandoning/stopping the workflow does not clean it up. The script is here.
  • Find the V1 releases that are older than X days and delete them using this script.
  • Restore a deleted V1 release from the backup db using this script
  • Check whether the update stats job is running or not using this script.
  • Best practices document which talks about what you should keep in mind or practice while managing RM 2015 server.

Enjoy !!

Comments (9)

  1. Peter Ibbotson says:

    Are these scripts good for RM2013? My first look suggests they should be.

  2. Yes and No.

    Yes because logically things are still the same in the wpf based RM server and No because physically schema has changed like table names start with tbl_ etc.

  3. Peter Ibbotson says:

    Thanks for that, I do however have a need to delete some releases so I can delete a stage out release manager 2013 (see link for long explanation).

    stackoverflow.com/.../release-management-2013-delete-stage-release

    Is it possible to get a 2013 version of these scripts? While I'm sure I could I convert these myself I suspect corporate policy wouldn't let me run scripts that aren't from Microsoft on the database.

  4. Peter Ibbotson says:

    Just like to say that for the diagnostic bits (i.e. workflow cleanup) I'm happy to change the scripts just not for the bits that modify the database.

  5. In case you want to do some specific operation, I can create a 2013 version of the script and send it to you.

  6. Peter Ibbotson says:

    Thanks for the offer, don't do anything just yet (delete release seems most likely), I'll need to get assorted approvals in place to run this sort of script on a live database so don't put the effort in until I've had more discussions at work.

  7. PeterIbbotson says:

    If you could port back to 2013 "the delete release older than 90 days" script that would be great.

    Thanks peter.

  8. Bruno says:

    Same than Peter, If you could port back to 2013 "the delete release older than 90 days" script that would be great

    best regards

  9. I have not tested the 2013 version of delete script that well but my hope is that it should work. In case any of you want to try it out on a test instance and report issues, I will be happy to fix them and this time I will be much more responsive.

    https://msdnshared.blob.core.windows.net/media/2016/03/Delete2013U4_V2.zip

Skip to main content