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
Tag: storage
SWEET! you can now access windows Azure Storage Directly from SQL Server Management Studio. This means you can now simply right click on a backup taken in SQL Azure and select “Import Data-Tier Application” to import the “bacpac” file onto your on-premise SQL Server. 2-3 clicks of the mouse and cloud zapped to local database. … Continue reading Accessing Azure Storage from SSMS in SQL 2012 RTM