Using MAP Tool and Excel to Analyse IO for SQL Consolidation. Part I – basic distribution

The Microsoft Assessment and Planning Toolkit is a fantastic tool for helping gather resource usage for a SQL consolidation / virtualisation project. http://technet.microsoft.com/en-us/library/bb977556.aspx One thing that is quite basic though is its presentation of disk IOPS (see below). This article shows how to analyse the data in a bit more detail using the underlying SQL … Continue reading Using MAP Tool and Excel to Analyse IO for SQL Consolidation. Part I – basic distribution