• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2057
  • Last Modified:

ASYNC_IO_COMPLETION wait type when trying to create new database

I am trying to create a new database on SQL 2005.  I have tried to do this through enterprise mgr and QA and it never completes.  I have to kill the process.  When I go and look at the process I notice that the wait type is the following when it is trying to create the new database:


any ideas?
  • 2
1 Solution
Michael WorshamInfrastructure / Solutions ArchitectCommented:
How big is the database you are trying to create and what kind of hardware is the database running off of?
H-SCAuthor Commented:
the database is empty, brand new no tables...just a right click and create database command.
Michael WorshamInfrastructure / Solutions ArchitectCommented:
Even though this might not be your issue, perhaps it can shed some light for creation of databases and disk hardware bottlenecks.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now