I was messing around while at #sqlsat275 with Mark Stacy (blog) and Glenn Berry (blog)with a goal to benchmark some Azure images to see if different VM’s had different performance profiles CPU and memory speed in the Amsterdam data centre. We used geekbench which is available here: http://www.primatelabs.com/geekbench The initial conclusion is that while there … Continue reading Tip: Getting the good hardware in Azure
Tag: Performance
When migrating a SQL Server workload we need to think about a few things A baseline of what resources our workload needs, at normal and peak operation, often we may just capture performance counters for CPU, Disk, maybe some SQL Server counters such as Batch Requests per second and ideally a business counter such as … Continue reading IOPS Planning for SQL Server in Azure IaaS