By Bob Duffy6. April 2011 11:43 As mentioned previously (http://blogs.prodata.ie/post/Using-MAP-Tool-and-Excel-to-Analyse-IO-for-SQL-Consolidation-Part-I-e28093-basic-distribution.aspx), the MAP tool has a nice database containing all your disk IOPS data and this is nicely contained in a single table called “performance_disk” We can use PowerPivot to analyse the IOPs form different perspective and start to apply some logic such as: excluding non-business hours, … Continue reading Using MAP Tool to Analyse IO for SQL Consolidation. Part II – Using Power Pivot
Tag: storage
Storage area networks are getting larger and more sophisticated. One of the problems I face as SQL consultants is running sqlio on them. One common stumbling block is the size of the cache on some storage area networks can be huge (128GB plus), especially with the use of solid state devices as a tier “zero” … Continue reading SQLIO tip #1 Dealing with large SAN cache