TechNet Support WebCast: Administering and maintaining the tempdb system database in Microsoft SQL Server (834846)



The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
  • Microsoft SQL Server 2000 (all editions) 8.0
  • Microsoft SQL Server 2000 (all editions) Release A
  • Microsoft SQL Server 2000 (all editions) SP1
  • Microsoft SQL Server 2000 (all editions) SP2
  • Microsoft SQL Server 2000 (all editions) SP3
  • Microsoft SQL Server 2000 (all editions) SP3a

Session Summary


Thursday, February 19, 2004

This Support WebCast session will discuss the role of the tempdb system database in typical Microsoft SQL Server operations. It will provide a review of the tempdb configuration and specifications, and describe some of the administration and maintenance tasks related to the tempdb database. The session will talk about planning activities, expanding and shrinking tempdb, moving it to another drive, and optimizing its performance. The Support WebCast will also discuss some of the known issues and challenges with maintaining tempdb.

This is a Level 200 session that will be presented by Jivko Dobrev.
Jivko Dobrev was born in Sofia, Bulgaria. He joined Microsoft (in the Bulgarian office) in 1999 as a Systems Engineer working with the Enterprise group on presales technical support tasks. Jivko joined the Product Support Services SQL Server group in 2001 and works with a wide variety of customers around the world. He holds MCSE, MCDBA, and MCSD certifications.

Viewing the Presentation


View this Support
		  WebCastTo view, click this link: View this Support Webcast (Length: 1 hour 36 minutes)

This Windows Streaming Media archive requires an Internet connection of 28.8 Kbps or faster, and is best viewed with a minimum screen resolution of 800 X 600.

Additional Resources


Download the
		  presentationDownload presentation - This is a Microsoft PowerPoint (.ppt) file.
If you do not have PowerPoint and you want a copy of the slides, use the PowerPoint Viewer (1,911 KB).
Read the
				transcriptRead the transcript from this Support WebCast


Provide feedback about this broadcast




Support WebCasts Home

Modification Type:MajorLast Reviewed:3/8/2006
Keywords:kbdownload kbtshoot kbtshoot kbWebCastSupport KB834846