Measuring the real performance cost of SQL Server XE buffers
Are Extended Events always lightweight? See how a bad config converts event loss into query latency through DMVs.
Are Extended Events always lightweight? See how a bad config converts event loss into query latency through DMVs.
As promised in my latest blog, I will talk about improvements in the detection of the availability group replication latency. As a reminder, replication latency between high available replicas may be monitored in different manners so far. Firstly, in my experience I had the opportunity to use different performance counters as “Database Replica:Transaction Delay” and “Databas Replica:Mirrored Write Transactions/sec” in…