sqlgorilla's profile picture.

David Koth

@sqlgorilla

คุณอาจชื่นชอบ

I support 'SQL Server 2019: Seeing a lot more SCH_M locks vs same load on SQL 2…' - what do you think? feedback.azure.com/forums/908035-…


Has anyone encountered this?

#sqlhelp Seeing longer blocks with the blocked process showing a waitresource like "METADATA: database_id = 459 METADATA_CACHE($hash = 0x16b953fd:0x0), lockPartitionId = 0" and transactionname of "CMEDCacheEntryFactory::FindOrCreateCacheEntry" Thoughts?



#sqlhelp Seeing longer blocks with the blocked process showing a waitresource like "METADATA: database_id = 459 METADATA_CACHE($hash = 0x16b953fd:0x0), lockPartitionId = 0" and transactionname of "CMEDCacheEntryFactory::FindOrCreateCacheEntry" Thoughts?


#sqlhelp SQL Server 2017 PBM (RTO and RPO) throwing violations in error log but policies evaluate that there are no issues. There is no ExecuteSQL() calls so there should not be any permissions issues and they all worked fine on SQL Server 2016


Just entered to win a gold iPad Air 2 + gold iPhone 6 in the #GoldenApple Giveaway. Enter here... stacksocial.com/giveaways/the-… via @StackSocial


SQL Server 2014 perf issues further explored... Cardinality estimator chokes on comp. mode 120 on query hitting empty tables #sqlserver


SQL Server 2014 - perf issue. cannot even get est exec plan in compat 120 for a certain call. suggestions? #sqlserver


An intro to a series of posts to come on handling a large environment with Availability Groups as the focal point: wp.me/p4noFI-p


Another day in the Amazon Jungle! Prepping a migration of 2500 databases from the data center to the cloud. Round 3.


How do I create a linked server for an AG Listener that is in a multisubnet configuration? #sqlhelp #sqlserver


United States เทรนด์

Loading...

Something went wrong.


Something went wrong.