• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2045
  • 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:

ASYNC_IO_COMPLETION

any ideas?
0
H-SC
Asked:
H-SC
  • 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?
0
 
H-SCAuthor Commented:
the database is empty, brand new no tables...just a right click and create database command.
0
 
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.

http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic2662.aspx
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

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