Azure Database for MySQL server has a slow query log now
I’m not sure when this feature got introduced, but I just saw it for the first time recently (and I asked for it when Azure Database for MySQL server was in private preview); but Azure Database for MySQL server can show you the slow queries that are running against the MySQL database. In fact, it’ll…
The post Azure Database for MySQL server has a slow query log now appeared first on SQL Server with Mr. Denny.
Free Performance Metrics from Traffic Manager
A couple of weeks ago DCAC moved our website from being hosted in a single data center to being a globally distributed web application with multiple Azure WebApps with one hosted in the US and one in Europe. As part of having traffic manager configured and enabled for our site, we get some free reporting…
The post Free Performance Metrics from Traffic Manager appeared first on SQL Server with Mr. Denny.
Cost Threshold for Paralellism
Cost Threshold for Parallelism is a setting in SQL Server that’s been around for as far back in the product that I can think of. It decides how expensive an operator needs to be because SQL Server will use multiple threads for that operator instead of a single thread. The Cost Threshold for Parallelism setting…
The post Cost Threshold for Paralellism appeared first on SQL Server with Mr. Denny.
Making WordPress a globally distributed application on Azure WebApps
Before I start, I’m just going to say that if I can do this with WordPress, then it can be done with anything. The goal that I was going for to have a WordPress website that was running on multiple contents (I only used two regions, but this can be scalled out as needed to…
The post Making WordPress a globally distributed application on Azure WebApps appeared first on SQL Server with Mr. Denny.