• Hi Robert - good news! This analysis does not need SQL Server 2016. Run the DMV query, save the results to a CSV and then use R to read the CSV and analyse it like any other data set.

    There is one big caveat here; that the analysis primarily focuses on the way that data is being read from tables, i.e. poor indexing or nasty queries. Common issues like memory, CPU, disk, recent changes in the environment etc. should be excluded as well.

    Regards,

    Nick