I am asked by clients/team members/friends a lot about how to set up TEMPDB to use the D:\ drive on an Azure VM for SQL Server. Below are the steps I took to configure it on my VMs.
At one of my previous DBA jobs, I encountered some performance issues in our Azure PaaS offering. Clients were experiencing 30-40 second login times and 10-15 second save times, which is considered poor. Of course, everybody’s first thoughts were, “THE DATABASE IS SLOW!!” After pulling up every single chart and metric I could, I finally proved to them it was not the database.
Continue reading Azure DBaaS Alerts
One of the sessions I give at PASS events is about configuring your on-premises SQL instance. I have also been working with Database-as-a-Service, DBaaS, for a while now and thought it would be helpful to do a session on configuring DBaaS for beginners. The purpose of this blog post is to list some of the things that I believe are crucial for first time deployment
Continue reading Configuring AzureDB DBaaS