Adam Machanic

Results 35 comments of Adam Machanic

Can you provide some more background on why you want this information? Especially, looking at your implementation, why you'd want to be able to filter on this? Reading your initial...

> @amachanic not sure what happened here, but essentially the whole PR is a conflict. It might be easier to re-base and make the one change again. I removed all...

Thanks. I need to figure out this line breaks thing. If I close the PR it's because I've not figured out a good way to fix it in place here;...

@jeffrey-yao Sorry for the delay in getting back to you on this. Does this happen for every restore? Is anyone else seeing this?

Thank you @codykonior for your detective work here. I'd really like to better understand the problem before creating any sort of fix - and at least in my case that...

@MaxShoshin In addition to the above, for the impacted databases, can you please tell us the value of the `secondary_role_allow_connections_desc` column in the `sys.availability_replicas` view?

What version of SQL Server? The slightly-off numbers (at least in the 1,000 range) are easy to rationalize based on timing. Obviously 3MM milliseconds in a second would be a...

Thanks @jzabroski. I'll get to work on that.

Correct, sys.dm_os_threads/workers. I think however that my complex workaround is not necessary in new versions of SQL Server, and that the correct thing to do here is to not delta...