Is my VM hyperthreaded?
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.
Articles by Andy
Always On Synchronous Commit Mode With Large Delays
Question For SQL Server Enterprise’s Always On availability groups in Synchronous Commit mode, is there some amount of latency that can’t be exceeded? For example, can it work between very distant data centers, such as between the US and Europe? asked 2020-10-18 by uncaged Answer … [Read More]
Replication of only updates and inserts
Question I have two sql servers, in the first I want to keep the data from the last three months and in the second I want to keep all the data with the purpose of getting historical reports. I know how to do a transactional … [Read More]
sp_update_schedule says @schedule_id does not exist
Question I wrote a script that reads job schedules from msdb.dbo.sysschedules and runs sp_update_schedule to change the active_start_time for a given subset of jobs. In each case, sp_update_schedule fails with the message "The specified @schedule_id(‘xxx’) does not exist". (MessageID 14262, Severity 16) Is the schedule … [Read More]
Multi-subnet availability group, with mixed MultiSubnetFailover support (Part 2)
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]
Multi-subnet availability group, without MultiSubnetFailover support (Part 1)
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 Azure hack for social justice
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]
Can we enable tls 1.0 on MSSQL Server 2019 on database level? if yes then how?
Question i am running sql server 2019 on Linux box and trying to connect using a Windows server 2016 client, how can we enable TLS 1.0 for SQL Server 2019 on the Database/instance level. TIA. asked 2020-09-25 by Rafay Pervaiz Answer TLDR You don’t. Long … [Read More]
SQL Server 2019 Database stuck In Recovery state after restart
Question SQL Server was restarted by mistake, when it came online, database came back in "In Recovery" mode. Check from error it says "Recovery of database ‘DB1’ (5) is 8% complete (approximately 27146 seconds remain). Phase 2 of 3. This is an informational message only. … [Read More]
How to dig deeper into ASYNC_NETWORK_IO waits
Question I’ve been handed a graph that comes from SolarWinds showing top wait events broken down by day. The last 2 days there’s a part of the daily color coded bar representing a total of 3 hours for ASYNC_NETWORK_IO. Still trying to see if I … [Read More]