[Pluralsight.
|
||||||||||||||||||||||||||||||||||||||||||
|
Home » Training video » Computer video tutorials and educational interactive discs » Microsoft OS and server programs |
| DL-List and Torrent activity | |
| Size: 448 MB | Registered: 9 years 2 months | Completed: 7 times | |
|
|
| Author | Message | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Download Windows ® Gender: Longevity: 10 years Posts: 6889
|
SQL Server: Understanding and Using DBCC Commands
Год выпуска: 2016 Производитель: Pluralsight.com Сайт производителя: https://www.pluralsight.com/courses/sql-server-understanding-using-dbcc-commands Автор: Erin Stellato Продолжительность: 02:18:00 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: Этот курс подскажет вам какие команды DBCC можно использовать для повышения производительности SQL Server. Продемонстрируется использование команд DBCC, а также их замены - Dynamic Management Objects, а также сценарии того, когда их лучше использовать. В арсенале администраторов и разработчиков баз данных существует множество команд DBCC. Некоторые их них будут чрезвычайно полезны, другие могут посеять хаос на рабочем сервере. В этом курсе вы изучите команды DBCC, которые будут полезны и актуальны и для администраторов, и для разработчиков (этот курс применим к любым версиям SQL Server, начиная с 2005 и выше). Сперва вы охватите большинство основных и информационных команд - в каких случаях и как их нужно применять, минимизировав влияние на рабочее решение. Далее вы узнаете о сервисных командах и как узнать, когда DBCC команда может быть заменена на Dynamic Management Object, вместе с примерами того, как их использовать. В заключение вы изучите недокументированные DBCC команды и пройдете по сценариям того, когда их использовать. К тому времени вы уже будете отлично понимать DBCC команды и вполне сможете использовать их для оптимизации своей среды. Описание на английском: This course will teach you which DBCC commands to use to enhance your production environment in SQL Server. You'll see demos of how to use DBCC commands, along with replacement Dynamic Management Objects, as well as scenarios for when to use them. There are many DBCC commands available to database administrators and developers. Some are for the greater good; others can wreak havoc in a production environment. In this course, SQL Server: Understanding and Using DBCC Commands, you'll explore DBCC commands that are useful and relevant, whether you're a DBA or a developer (this course is for SQL Server 2005 and up). First, you'll cover the most basic commands and the informational commands--when to use them and how, in order to minimize impact on the solution. Next, you'll learn about the maintenance commands and how to recognize when a DBCC command has been superceded by a Dynamic Management Object, along with examples of how to use them. Finally, you'll learn about undocumented DBCC commands and go through scenarios on when to use them. By the time you're done, you'll have a greater understanding of DBCC commands and you'll be able to use those commands to optimize your environment. СодержаниеCourse OverviewIntroduction Introduction and Responsibilities of a DBA What This Course Covers Course Structure and Module Summary Basic Commands Introduction and What Are DBCC Commands? DBCC Resources Testing DBCC Commands Undocumented Commands DBCC HELP DBCC TRACEON, DBCC TRACEOFF, and DBCC TRACESTATUS Demo: Using Basic DBCC Commands Takeaways and Module Summary Informational Commands Introduction DBCC SQLPEERF Demo: Using DBCC SQLPERF DBCC SHOW_STATISTICS Demo: Using DBCC SHOW_STATISTICS DBCC USEROPTIONS Additional Commands and DBCC OPENTRAN DBCC INPUTBUFFER and DBCC OUTPUTBUFFER DBCC PROCCACHE and DBCC SHOWCONTIG Demo: Using DMOs Instead of DBCC Takeaways and Module Summary Maintenance Commands Introduction and DBCC DROPCLEANBUFFERS DBCC FREEPROCCACHE DBCC FREESYSTEMCACHE and FREESESSIONCACHE DBCC FLUSHPROCINDB Demo: Commands to Clear Buffer Pool and Procedure Cache DBCC SHRINKDATABASE and DBCC SHRINKFILE Demo: Effects of SHRINK Commands DBCC UPDATEUSAGE and DBCC CLEANTABLE Deprecated Commands, Takeaways, and Module Summary Validation Commands Introduction DBCC CHECKCONSTRAINTS Demo: Using DBCC CHECKCONSTRAINTS DBCC CHECKIDENT Demo: Using DBCC CHECKIDENT Takeaways and Module Summary Undocumented Commands Introduction and DBCC LOGINFO Demo: Using DBCC LOGINFO DBCC IND, DBCC PAGE, and DBCC DBINFO Demo: Exploring Internals with DBCC Commands Takeaways and Module Summary Where to Go Next and Course Summary Видео: AVC, 1280x720, 16:9, 15 fps, 147 Kbps Аудио: AAC, 44.1 KHz, 96 Kbps, 2 channels
 |
|||||||||||||||||||
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon} ![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon} |
||||||||||||||||||||
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
|
|
Home » Training video » Computer video tutorials and educational interactive discs » Microsoft OS and server programs |
Current time is: 07-Jun 17:37
All times are UTC + 2
You cannot post new topics in this forum
You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum |