Sunday, April 10, 2011

high PAGEIOLATCH_SH in transactional replication?

it turned out that when setting up replication, the default behavior is to remove nonclustered indexes.

No comments:

Disable Microsoft Defender for Cloud for Visual Studio Subscription (MSDN)

I use a visual studio pro subscription which comes with $150 azure cloud credit, for some reason Microsoft Defender for Cloud was turned on ...