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.
SQL Server Performance Monitor Objects
Monitoring SQL Server Performance Monitor objects (Perf Mon for those in the know) can be an important part of monitoring your SQL Server instance. Finding information about the performance monitor objects that SQL Server exposes can be tricky, even though the SQL Server Project Team can documented what these objects all mean. You can find…
The post SQL Server Performance Monitor Objects appeared first on SQL Server with Mr. Denny.