Question I am trying to figure out the way to monitor these 2 events log send queue size – I can see this in perfmon Redo queue size – I can see in dmv but not in perfmon counter Is there any way of using … [Read More]
RonJohn needs to know if his VMs are hyperthreaded. I point him to vCenter for a definitive answer, and to a SQL Server DMV for the next best thing.
In yesterday’s post, I showed how to configure an availability group (AG) to use the RegisterAllProvidersIP=0 when you can’t get clients to connect using the MultiSubnetFailover=true connection string attribute. I mentioned that you have to make some trade-offs when you set RegisterAllProvidersIP=0, and included this … [Read More]
As a DBA, we have the opportunity & responsibility to build highly available database platforms for use by applications & users. Even if you are a DBA at a small company supporting databases for only internal applications, we are usually still responsible for providing databases … [Read More]
Microsoft is going to be running a virtual hackathon, running from October 12 through November 20. The theme of the hack will be to use Microsoft Azure to address some social justice issue. I’m thrilled to be joining the judging panel for this event, which … [Read More]
Copyright © 2024 | Andy Mallon | am2.co