Many organizations have already deployed or plan to deploy databases in the cloud, both in Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) implementations. People who move to the cloud might think everything's completely hands-off, but monitoring and optimization is even more critical because you share resources and have no control over the infrastructure. So, how do you address your SQL Server performance challenges?
The goal of this presentation is to give you a set of steps you can follow that will detect and fix a lot of the most common SQL Server performance issues you'll encounter.
Whether you are running in an on-premises or cloud environment, your virtualized storage may not have the performance needed to support your user base. Don’t be misled, there are options in SQL Server, Windows and your infrastructure beyond upgrading your SAN or hardware to improve your performance.