logical reads and physical reads in sql server | Sql server performance tuning Part 11

preview_player
Показать описание
What is the difference between Physical and Logical Reads in SQL Server

SQL Server performance tuning interview questions and answers

Part-10 (Set statistics io on and Set statistics time on)

For Quiz-

Find Us On FaceBook-
  1. SS UNITECH
  2. sql server logical reads very high
  3. logical reads vs physical reads oracle
  4. monitoring physical reads sql server
  5. sql server reads writes
  6. sql logical vs physical read
Рекомендации по теме
Logical Reads vs 0:08:49

Logical Reads vs Physical Reads

Why Logical Reads 0:17:13

Why Logical Reads Are A Bad Metric For Query Tuning In SQL Server

What Are Logical 0:01:47

What Are Logical Reads

Logical Reads and 0:00:59

Logical Reads and Physical Reads

logical reads and 0:11:00

logical reads and physical reads in sql server | Sql server performance tuning Part 11

SQL Server Interview 0:01:32

SQL Server Interview | What is the difference between Physical and Logical Reads in SQL Server

lob logical reads 0:03:11

lob logical reads and lob physical reads in sql server | Sql server performance tuning Part 12

Optimize a query 0:02:13

Optimize a query reducing logical reads

TEAS 7 Reading 2:31:48

TEAS 7 Reading - All In One - Part 3 of 3 - Integration of Knowledge and Ideas - October 2024

Databases: Difference between 0:02:30

Databases: Difference between logical and physical reads/writes

SQL : what 0:01:02

SQL : what is logical reads in sql server? how to reduce no of logical?

CPU impact, Scan 0:02:57

CPU impact, Scan count 9, logical reads 1686, physical reads 0 vs Scan count 1, logical reads...

LIVE Troubleshooting on 0:17:51

LIVE Troubleshooting on Production Server – Physical vs Logical IO (by Amit Bansal)

Databases: Why so 0:02:33

Databases: Why so many logical reads? (3 Solutions!!)

Databases: SQL Server 0:01:53

Databases: SQL Server Logical IO Block Sizes and Physical Reads

Databases: Number of 0:02:37

Databases: Number of logical reads in SQL server JOIN

Databases: logical reads 0:02:31

Databases: logical reads vs. scan count (2 Solutions!!)

STATISTICS IO, TIME 0:04:57

STATISTICS IO, TIME - DBA Fundamentals Quick Tip

Detect Worst Performing 0:09:58

Detect Worst Performing Queries - Part1

Why more (and 0:03:04

Why more (and varying number of) logical reads with read ahead (prefetch)?

Determine total no 0:01:42

Determine total no of logical/physical reads (2 Solutions!!)

1 Basics 0:11:48

1 Basics Query plan, Logical operators and Logical reads

Databases: Total logical 0:03:20

Databases: Total logical reads per database on SQL Server (2 Solutions!!)

Databases: Difference between 0:02:47

Databases: Difference between Physical Reads and Read-Ahead Reads (2 Solutions!!)

Комментарии
Автор

Your explanation is really grt and thank u for giving us that valuable information. I had a question if in an interview asked what is sql performance tunning and how you can achieve it ? so can you pls explain me there are different way to improve sql performance tunning . which one should i explain in any interview and how? Thank in advance

monikaparvin
Автор

3:54 in note is stated, that: "scan count=0...OR select all the without any condition..." but then in the table when you do so(right the first select on Person table) your SCAN COUNT is 1. This doesn't make any sense. DBCC TRACEON(652) doesn't work for me MSSQL Server 2014, I'm always getting read-ahead reads 😕

UmpikLumpik
Автор

Hi sir, one doubt, in this video u r executing same query only, but how u r getting one time physical reads zero and another time some count, please tell

shaiksharief