Today (December 24th, 2018) is the last day that you can click through to our DCAC’s Happy Holiday’s page, which just my visiting the page will trigger us to donate $1 to the Elizabeth Glaser Pediatric AIDS Foundation. If you come to the page after December 24th, 2018 you can still make a donation by clicking through on the page to make your own donation.
If you aren’t familer with the Elizabeth Glaser Pediatric AIDS Foundation; they have assisted 27 million pregnant women at more than 5,000 clinics in 19 African countries, The Elizabeth Glaser Pediatric AIDS Foundation continues to seek an end to global pediatric HIV/AIDS through prevention and treatment programs, research, and advocacy.
Needless to say, EGPAF is a great founation for Denny Cherry & Associates Consulting to be team up with. So click through, and we’ll make a donation.
The post Last Chance To Click Thru To Make A Donation appeared first on SQL Server with Mr. Denny.
Tis the season and Denny Cherry & Associates Consulting has a quick way for you to make a difference. All you have to do, is click through to our donation webpage, and that’s it. For clicking through, DCAC will donate $1 to Elizabeth Glaser Pediatric AIDS Foundation.
Every dollar accessed by your participation matters. Having assisted 27 million pregnant women at more than 5,000 clinics in 19 African countries, The Elizabeth Glaser Pediatric AIDS Foundation continues to seek an end to global pediatric HIV/AIDS through prevention and treatment programs, research, and advocacy.
Want to DONATE MORE? EXCELLENT! We’re matching funds! Click through here to donate to EGPAF!
The post View a website, make a donation appeared first on SQL Server with Mr. Denny.
If you’re using Windows 2016 in, its default config you may not get getting the IO performance that you were expecting. If you try a Windows 2012 server, the problem magically goes away. The question is why.
The answer is shockingly straightforward, Windows 2016 ships with Windows Defender installed by default, where Windows 2012 R2 didn’t. Windows Defender, if not disabled by GPO can have a significant impact on your server. On a client machine in Azure that was having the issue, DiskSpd on a disk which should have 7500 IOPs available was getting just 1100. The same applied to a stripe of 1TB disks which should have given us 20,000 IOPs was also seeing only 1100 IOPs. As soon as we disabled Windows Defender, we got the speed we were expecting.
Now I’m not going to recommend that you disable Windows Defender automatically, but you’ll want to set exclusions for it to ignore MDF and LDF files as well as BAK files (and any folders that you’re using for FILESTREAM data) so that Windows Defender it’s making your SQL Servers extremely slow.
The post IO Performance in Windows 2016 appeared first on SQL Server with Mr. Denny.
Azure is a great platform to use, and the new Managed Disks are fantastic as you just need to set it and forget it. However, if you run into the problem that I can recently with moving the VM from one resource group to another, you’ll run into a stumbling block pretty fast. I hit this because I put a VM in the wrong resource group, then the customer installed a bunch of software of the VM, then I went to move it to another resource group. That’s when I got the lovely error that said “Operation ‘move’ is not supported on Resource ‘MyVM’ with managed disks. (Code: BadRequest)”.
This error was a bit of a problem as I didn’t want to blow away the VM. I had to turn on a couple of Azure features in PowerShell (eventually you won’t have to do this, maybe you don’t have to do this already) and I was able to move the VM without issue. After running the following commands (and using Get-AzureRmProviderFeature to wait for the feature to be registered), the move worked.
Register-AzureRmProviderFeature -FeatureName ManagedResourcesMove -ProviderNamespace Microsoft.Compute
Register-AzureRmResourceProvider -ProviderNamespace Microsoft.Compute
At this point, I was able to move the VM and all it’s resources to the correct resource group using either PowerShell or the Azure Portal (I assume CLI worked as well, but I didn’t need to do more testing).
The post Moving VMs in Azure with Managed Disks Between Resource Groups appeared first on SQL Server with Mr. Denny.