October 28, 2014 at 9:08 am
Hi
We provisioned a vm with OS of Windows 2012R2 with SQL Server 2012. I am hearing about problems with performance. Does anyone know of a checklist that I could go through to make sure my SQL Server is provisioned appropriately?
Thanks
Kathy
October 28, 2014 at 10:45 am
The usual culprits with all virtualized sql servers apply. Under-provisioning of RAM and especially IO are rampant. Beware a chatty application too unless it is self-contained on the VM.
http://go.microsoft.com/fwlink/?LinkId=306266
http://msdn.microsoft.com/en-us/library/azure/dn133149.aspx
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
October 28, 2014 at 11:16 am
You should treat any SQL Server instance on a cloud VM the same way you'd treat it on a local VM or even on local hardware. You look to performance metrics, wait stats and query metrics to understand what is running slow and why it may be running slow. The main differences are that you won't literally upgrade hardware. Instead you'll need to make sure you have a properly provisioned VM (memory and CPU are still necessary to run SQL Server) and that you configured your disks appropriately.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 29, 2014 at 12:32 pm
Thanks for the input. I'll do more research and traces and analysis to try and determine our problems
Kathy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply