SQL Server Performance

what is IMPPROV_IOWAIT type

Discussion in 'SQL Server 2005 General DBA Questions' started by Varma, Jul 1, 2009.

  1. Varma New Member

    Hi,
    Can anyone let me know what is IMPPROV_IOWAIT type in Active Monitor. I am getting following message in Active Monitor.IMPPROV_IOWAITIO / ResourceWaiting for bulk data load IO operation to finish.
  2. Luis Martin Moderator

    Welcome to the forums!!!
    Check: http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/Performance_Tuning_Waits_Queues.doc
  3. Varma New Member

    Thanks Martin,
    I hope the document in the given link will help.

Share This Page