David Koth

[David Koth @sqlgorilla]

@UncleTonyJr

[David Koth @sqlgorilla]

Others noticed too. Just alerting you to the occurrence as it interrupts a great course.

[David Koth @sqlgorilla]

Hi Stephane. Over the last week I notice a lot of buffering with https://t.co/ErvaRYJOa6

[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? https://t.co/5SxuilXl4R

[David Koth @sqlgorilla]

Has anyone encountered this?

[David Koth @sqlgorilla]

#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?

[David Koth @sqlgorilla]

#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?

[David Koth @sqlgorilla]

#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

[David Koth @sqlgorilla]

Go Bolts game 5!

[David Koth @sqlgorilla]

@TBLightning suite 65 seat 25 #boltsand47brand

[David Koth @sqlgorilla]

Just entered to win a gold iPad Air 2 + gold iPhone 6 in the #GoldenApple Giveaway. Enter here... https://t.co/zpVTDQEX2z via @StackSocial

[David Koth @sqlgorilla]

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

[David Koth @sqlgorilla]

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

[David Koth @sqlgorilla]

An intro to a series of posts to come on handling a large environment with Availability Groups as the focal point:
http://t.co/twKcO9Mpb6

[David Koth @sqlgorilla]

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

[David Koth @sqlgorilla]

@mecheph @BrentO We tried that as well. No luck but the work-around worked like a charm.

[David Koth @sqlgorilla]

@BrentO No way I can find for the multisubnetfailover=yes in the linked server. No worries. Thx again.