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

  • Anonymous
    January 14, 2016
    Are these scripts good for RM2013? My first look suggests they should be.

  • Anonymous
    January 14, 2016
    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.

  • Anonymous
    January 14, 2016
    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.

  • Anonymous
    January 14, 2016
    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.

  • Anonymous
    January 15, 2016
    In case you want to do some specific operation, I can create a 2013 version of the script and send it to you.

  • Anonymous
    January 17, 2016
    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.

  • Anonymous
    January 25, 2016
    If you could port back to 2013 "the delete release older than 90 days" script that would be great. Thanks peter.

  • Anonymous
    February 01, 2016
    Same than Peter, If you could port back to 2013 "the delete release older than 90 days" script that would be great best regards

  • Anonymous
    March 08, 2016
    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