Loading...

#8 June 2011: Tempdb latch contention

1,331 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Dec 4, 2012

SQLskills Insider video from June 12th, 2011 newsletter.

One of the issues that we all know about is tempdb contention. I've blogged many times about this and there's a ton of other information out there too on how to reduce page latch contention in tempdb. However, there's one point of contention you can't do anything about so in the demo video (7 mins) this time I'm going to show you how to spot it.

Demo code: http://www.SQLskills.com/InsiderConte...

You can get all the Insider videos by joining our community, with a bi-weekly newsletter with an editorial, demo video, and book review. http://www.SQLskills.com/Insider.

Loading...

When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...