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
Watch video Measuring Sequential Read Performance in SQL Server online, duration hours minute second in high quality that is uploaded to the channel Glenn Berry 15 March 2021. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 609 times and liked it 29 visitors.
