Thanks to everyone who attended my session. Here are some links that might be useful for further reading: - Presentation Deck (attached to this blog) - Microsoft Assessment and Planning Application Toolkit http://www.microsoft.com/downloads/en/details.aspx?FamilyID=67240b76-3148-4e49-943d-4d9ea7f77730&displaylang=en - Sql Consolidation Planning Add-In for Excel http://www.microsoft.com/downloads/en/details.aspx?FamilyID=eda8f544-c6eb-495f-82a1-b6ae53b30f0a - Demo of using MAP and Excel to produce IO Histogram http://blogs.prodata.ie/post/Using-MAP-Tool-and-Excel-to-Analyse-IO-for-SQL-Consolidation-Part-I-e28093-basic-distribution.aspx - Demo … Continue reading SQL Consolidation Planning Session at SqlBits 8
Tag: SQL IO
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