Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Learn about SQL Server DBA, SQL Server database performance,SQL Server optimisation,database tuning,t-sql,ssis
Browse by Tags · View All
DBA Scripts 51
performance 37
SQL Server 29
Object Management 24
#SQLServer 24
Backup and Restore 20
Security Management 20
Powershell 17
Indexes 14
DBA 14

Archive · View All
June 2011 38
January 2011 33
May 2011 32
August 2011 27
July 2011 26
January 2012 24
February 2011 19
April 2011 19
March 2011 17
March 2012 17

Jack Vamvas's Blog

SQL Server – read ahead

Mar 21 2011 7:48AM by Jack Vamvas   

On the SQL Server performance stack one of the potential performance bottlenecks is the read-ahead rate at the Cache level.

The relational engine manages the method of access and the buffer manager. The methods of access relates to table scans & index scans. The buffer manager accesses and updates database pages.

This is a very useful process. But the performance is dependant on the organisation of the data being prefetched. If the data is contigious – the Read Ahead manager can read large chunks of data at a single time. On the other hand if the data is mixed i.e scattered across the extents and mixed in with other objects, then this places a greater cost on retrieving the data.

In those situations, aim to make the data as contigious as possible. Decrease fragmentation levels.

Read-ahead is a database engine optimisation method. The theory is that the database engine will anticipate the requirement for data pages and index pages within a query, the manager will fetch the data and place it in the cache –in preparation for use.

While CPU is able to manage computational aspects of the query, the read ahead will read from disk. A read- ahead read will use a scatter – gather approach to placing in the buffer cache. Scatter – gather is ideal as it attempts to deal with moving data in and out of non- contigious memory areas. If the particular page already exists in the buffer cache, it will be discarded. As mentioned above, it is ideal to decrease fragmentation levels.

Read – ahead comes in two flavours: data page reads & index page reads

Reading data pages involves building a list of disk addresses via the IAM.Reading index pages for non clustered indexes uses prefetching . As the leaf pages are being scanned – the database engine will begin to retrieve rows that have already been scanned.

Republished from http://www.sqlserver-dba.com.


Republished from SQL Server DBA [65 clicks].  Read the original version here [32134 clicks].

Jack Vamvas
5 · 26% · 8528
0
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]