SQL Server 2017 to 2019 Upgrade – Error and lesson learned

When I was upgrading my SQL Server 2017 instance to SQL Server 2019 from a mounted ISO file, I encountered an error message during the upgrade process, “An error occurred for a dependency of the feature causing the setup process for the feature to fail.”. You can see the error in the illustration below. At first, it was not … Continue reading “SQL Server 2017 to 2019 Upgrade – Error and lesson learned”

Performance Decoder Ring

Get your top wait type with sp_BlitzFirst @SinceStartup = 1 If your top wait type is Then use @SortOrder = CXPACKET CPU and Reads separately SOS_SCHEDULER_YIELD CPU THREADPOOL CPU LCK_** Duration RESOURCE_SEMAPHORE Memory grant PAGEIOLATCH_** Reads WRITELOG Writes


Something went wrong. Please refresh the page and/or try again.

About Me

Hi, I’m Vinay Are. Sr. Database Engineer at Teladoc Health Inc. I spend my time with my daughter and wife when I am not working. In my spare time, I do landscape and macro photography as a hobby. This blog is for my love of databases, a place to store important things I want to remember about databases

Subscribe to My Blog

Get new content delivered directly to your inbox.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s