How to configure tempdb in SQL Server
Автор: Voluntary DBA
Загружено: 2013-12-01
Просмотров: 30894
The tempdb system database comes out-of-the-box with settings that don't perform well for many production workloads. In this video, Microsoft Certified IT Professional Jon Seigel explains three important considerations to configure tempdb for optimal performance, including an in-depth discussion about how to choose the number of data files to create.
Blog post:
http://voluntarydba.com/post/2013/12/...
How to enable Instant File Initialization:
• How to enable Instant File Initialization ...
Read more about sys.dm_os_waiting_tasks:
http://technet.microsoft.com/en-us/li...
Read more about sys.dm_os_wait_stats:
http://technet.microsoft.com/en-us/li...
Read more about DBCC SQLPERF:
http://technet.microsoft.com/en-us/li...
sys.dm_os_waiting_tasks query to find PAGELATCH_* waits:
http://jsstatic.net/Content/SqlScript...
Visit my channel for more database administration videos:
/ voluntarydba
Subscribe to get notified about my latest videos:
https://www.youtube.com/voluntarydba?...
Read additional content on my blog:
http://voluntarydba.com
Follow on Twitter:
/ voluntarydba
Like on Facebook:
/ voluntarydba
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
