Measuring Sequential Read Performance in SQL Server
This video demonstrates how to measure your sequential read performance using SQL Server. This includes sequential read performance from your storage subsystem and sequential read performance from memory.
The two queries I use in the video are available here:
Measuring Sequential Read Throughput
http://bit.ly/3vscN21
Check Buffer Usage
http://bit.ly/3rUT3lB
⏱️TIMESTAMPS⏱️
0:00 Intro
0:18 What are we doing in this video?
1:21 Measuring sequential read performance from storage
4:20 Looking at the database in more detail
6:08 Looking at the storage subsystem
8:48 Measuring sequential read performance from memory
13:57 Reviewing what we have learned
16:13 Chorizo!
🔴 Please subscribe for more content like this!
SOCIAL
===============================
📝 - BLOG: https://glennsqlperformance.com/
🐦 - TWITTER: / glennalanberry
👥 - FACEBOOK: / glenn.berry.92
LinkedIn: / glberry
Host, Video: Glenn Berry
Смотрите видео Measuring Sequential Read Performance in SQL Server онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал Glenn Berry 15 Март 2021. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 609 раз и оно понравилось 29 посетителям.
