The Microsoft Dynamics Lifecycle Services (LCS) team is happy to announce the immediate availability of the release notes for LCS (September 2018).


Delete on-premises environment

In this release of LCS we have added the option to Delete an on-premises environment directly through the environment details page as shown below. The Delete button displays only if the environment is in a Failed, Deployed, or an Unknown state. When you click Delete, you will be asked to confirm the deletion action by signing your name.


Diagnose and mitigate performance issues on Sandbox and Production directly through LCS

In this release of LCS we’ve added a new feature that enables customers and partners to collect performance metrics on demand, and execute a pre-defined set of actions to mitigate issues in their Sandbox or Production environment. This feature is available on Sandbox and Production environments that are connected to SQL Azure and is only shown to users who are assigned the Environment manager role in their projects. Users who are assigned the Project owner role will not have access to this feature. With this feature, you can query for the root blocker, get fragmentation details, add/remove index, run update stats on a table, or terminate a blocking statement directly through LCS. One advantage of this feature is that it queries SQL directly, returning the results in near real time and thereby enabling you to quickly diagnose performance issues. There is also an audit trail in the environment history on the action performed, so you can go back and determine who performed the action and when. To use this feature, go to a specific environment in LCS and open the environment details page. Select the Environment Monitoring link in the Monitoring section. Click the SQL Insights tab to access this feature. You will see 3 new tabs displayed under SQL Insights:


  • Live View – Shows current DTU, executing statements, and blocking statements.
  • Queries – Shows a list of pre-defined queries that can be used to retrieve metrics on demand. Examples of queries include a current blocking tree, a list of active plan guides, get XML for a plan ID, and a list of most expensive queries.
  • Actions – Shows a list of pre-defined actions that should be taken to mitigate issues in the Sandbox and Production environments. Examples of actions include adding/dropping an index, updating stats on a table, rebuilding indexes, and terminating a blocking statement.

Because some of the capabilities of this feature overlap with the current functionality in LCS, we have consolidated the information in the available tabs under SQL Insights. With this change, the SQL Now tab that shows Current execution statements, blocking info, and lock info will be not be visible. All of this information is now available on the Live View page, which shows currently executing and blocking statements, and the Queries page, which shows the lock details in the Get Lock Details query.

Additional details on using this feature and a cookbook on query details and when it should be used will be available in shortly.