Stack Overflow
Stack Overflow

Questions tagged [logical-reads]

11 questions
39
votes
2 answers

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

After doing my research, on how to speed up queries executed in SQL server, the majority of resources suggesting to reduce logical reads, by using the proper where clause. What I am really interested in is to know about the work flow in SQL…
Nandha
  • 655
  • 1
  • 6
  • 14
3
votes
0 answers

Number of logical reads in SQL Server

I'm trying to understand how sql server works access data. For very simple queries I'm able to exactly calculate number of logical reads that are needed, but I've problem with following rather simple query: SELECT a.* FROM TT_TMP_3 AS a INNER JOIN…
Tomek Tarczynski
  • 2,785
  • 8
  • 37
  • 43
1
vote
0 answers

How to reduce worktable logical reads?

update #temp_Or_GetPendingOrdersList set ApprovedOn = dbo._UD_GetDate(dbo._UD_ConvertToCompanyTime(@HHA,#temp_Or_GetPendingOrdersList.ApprovedDate,#temp_Or_GetPendingOrdersList.branchid)) + ' '…
Raj Kumar
  • 65
  • 1
  • 8
1
vote
0 answers

SQL Server 2014 performances : logical reads

New focus : What parameters can have an impact on "number of logical reads" ? UAT and PROD environments are supposed to be the same but "number of logical reads" is huge for PROD. Exec plans on UAT & PROD Detailed problem => Not solved Thanks in…
Steph_P92
  • 35
  • 1
  • 5
1
vote
3 answers

inner join vs where clause subquery sql server

I am trying to speed up my stored procedure, so I test my stored procedure in two formats using statistics io like below Method 1: using join set statistics io on select top 2000 p.Vehicleno, dbo.GetVehicleStatusIcon1(p.Direction,…
Nandha
  • 655
  • 1
  • 6
  • 14
1
vote
1 answer

Why my SQL query is reading more pages but is faster?

I was testing some nonClustered indexes to be added in a table inside a view (that has 7 inner joins). After running Tunning Advisor (SQL Server 2008) it showed me a script to create a nonClsutered index in a table (a) that could help me to optimize…
Mucida
  • 603
  • 9
  • 24
1
vote
1 answer

Unit testing Sql for logical reads

We have unit tests for our data access layer. This has helped to spot sql syntax errors. Now that we have these tests I would like to take it one step further. I would like to run the unit tests and find sql that has a high number of logical reads,…
Eric Brown - Cal
  • 14,135
  • 12
  • 58
  • 97
0
votes
1 answer

how Indexing works in logical reads and what are the benefits

I want to reduce the logical reads to speed up the stored procedures execution time sql server, Later i come to know by using index i will find my solution. I need to know how indexing works and its benefits.
Nandha
  • 655
  • 1
  • 6
  • 14
0
votes
3 answers

Large number of "logical reads" on single row delete

When deleting a row by its PrimaryKey from a table, I get about 44472 logical reads. Now the table has 5-6 child tables that link their ForeignKeys to the PK of the table I want to delete from. I'm not sure what to do to improve the performance of…
sirrocco
  • 7,975
  • 4
  • 59
  • 81
0
votes
1 answer

SQL Logical Reads

I have a query that run a lot due to it being in a function that is called for a large row set. the query is SELECT @sql = NULL WHERE @sql = '' Even though this shows me 0 physical reads. It shows me around 17000 Logical Reads. Any explanations??
Storm
  • 4,307
  • 11
  • 40
  • 57
-1
votes
2 answers

How to find minimum number of trips to do in order to complete this work from point A to point B using javascript?

So I am solving this problem given as: There are bags carrying weights from 1 to 3 units and I have to carry them from point A to point B. Weights are given of bags in array. All weights are less than 3 unit. weights = [1, 1.78, 2.2, 2.73, 3] So I…
Biku7
  • 450
  • 6
  • 16