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 Async_io_completion and how to reduce it

Mar 24 2011 7:41AM by Jack Vamvas   

SQL Server Books online defines Async_io_completion as “Occurs when a task is waiting for I/Os to finish “

Mainly a symptom of an IO bottleneck. Cross check by identifying other wait stat indicators such as: IO_COMPLETION, WRITELOG,PAGEIOLATCH_X. The appearance of at least one of these along with ASYNC_IO_COMPLETION – near the top of the wait stats indicates a serious IO bottleneck.

Any SQL Server task waits for IO completion – this is completely normal part of SQL Server processing. But when the wait for IO completion is slow there is a problem.

A few issues to consider and approached to minimizing Async_io_completion.

1) Maintain Random access \ Sequential access files on different drives .

2) Are you experiencing IO delay messages in the error logs. This is a strong indicator, as it reports on IO delays – outside of the SQL Server process space.

the article: IO Requests taking longer than 15 seconds to complete gives an in depth explanation

3) Analyse the SQL Server Performance Stack

CPU Cores

Windows

SQL Server

Cache

FC HBA

Fibre Channel Switch

Storage Controller

Storage Controller Cache

Disk

LUN

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]