{"id":663,"date":"2014-09-25T22:52:01","date_gmt":"2014-09-25T22:52:01","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/visualstudioalm\/2014\/09\/25\/release-management-console-times-out-when-launched\/"},"modified":"2022-05-26T05:45:15","modified_gmt":"2022-05-26T13:45:15","slug":"release-management-console-times-out-when-launched","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/devops\/release-management-console-times-out-when-launched\/","title":{"rendered":"Release Management Console times out when launched"},"content":{"rendered":"

When the Release Management Console<\/strong> application is loaded, it defaults to the Traffic Overview<\/strong> page. If the database is not optimized, the query used to load such statistics may take a long time to execute. This may be due to recent updates such as an upgrade of your Release Management Server where existing statistics may now be staled.<\/p>\n

By default, SQL Server already handles updating such statistics as needed. However, you can force this update manually in order to expedite the process.<\/p>\n

If you are experiencing such delays, consider updating the Release Management database query optimization statistics<\/a> as follow:<\/p>\n

NOTE:<\/strong> To update the statistics on the database you should either be DBO<\/strong> of that database or SysAdmin<\/strong> on SQL instance.<\/em><\/p>\n

Using SQL Server Management Studio<\/h2>\n
    \n
  1. Launch SQL Server Management Studio<\/strong><\/a>.<\/li>\n
  2. Open a New Query<\/strong> window.<\/li>\n
  3. Paste the following script snippet in the query window.
    \nUSE [ReleaseManagement]
    EXEC sp_updatestats
    GO<\/span><\/li>\n
  4. Press F5<\/strong> to execute the command.<\/li>\n<\/ol>\n

    Using SQLCMD from the command line<\/h2>\n
      \n
    1. Save the following script snippet to a file called rm_updatestats.sql<\/strong>.
      \nUSE [ReleaseManagement]
      EXEC sp_updatestats
      GO<\/span><\/li>\n
    2. Locate the SQLCMD.EXE<\/strong> executable. It should be located in a path similar to C:Program FilesMicrosoft SQL Server110ToolsBinn<\/span>, depending on the version of and location where your SQL Server is installed.<\/span><\/li>\n
    3. Run the script file.\n
        \n
      1. Open a command prompt window.<\/li>\n
      2. In the Command Prompt window, type: sqlcmd \u2013S \u2013i [Path]rm_updatestats.sql<\/strong>
        <\/span>Where, <\/strong><\/span> is your specific server name instance; and [Path]<\/strong><\/span> is the location of the rm_updatestats.sql<\/strong><\/span> file.<\/span><\/li>\n
      3. Press ENTER<\/strong>.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

        Verify the results by loading the Release Management Console again and observing the improvements.<\/p>\n

        Update – Feb. 6, 2015<\/h3>\n

        NOTE:<\/strong> For customers with Update 4, we have added a scheduled job at the time of RM server configuration. If this has to run successfully, customers have to make sure SQL Server Agent is enabled on the DB
        \nserver hosting RM.<\/p>\n

        \"\" \n\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"

        When the Release Management Console application is loaded, it defaults to the Traffic Overview page. If the database is not optimized, the query used to load such statistics may take a long time to execute. This may be due to recent updates such as an upgrade of your Release Management Server where existing statistics may […]<\/p>\n","protected":false},"author":65,"featured_media":45953,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[226,1],"tags":[],"class_list":["post-663","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ci","category-devops"],"acf":[],"blog_post_summary":"

        When the Release Management Console application is loaded, it defaults to the Traffic Overview page. If the database is not optimized, the query used to load such statistics may take a long time to execute. This may be due to recent updates such as an upgrade of your Release Management Server where existing statistics may […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/663","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/users\/65"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/comments?post=663"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/663\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media\/45953"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media?parent=663"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/categories?post=663"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/tags?post=663"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}