Slow creating 170GB Database

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  January 18, 2012 at 1:47 pm

  #263045

  I'm creating several databases on a new server and I'm having trouble creating a Database with an initial size of 170GB.

  I executed the SQL and I canceled the query after 15 minutes.

  So I tried creating it with a smaller size and using the ALTER DATABSE COmmand to increase it to 170GB. That query has been running over 5 minutes.

  I'm the only one on the server.

  Any ideas on how I can overcome this?

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  January 18, 2012 at 2:11 pm

  #1435509

  Hmmm , that does sound slow. Could point to errors further down the stack ??

  Tried setting up Instant File Initialization ? http://sqlblog.com/blogs/tibor_karaszi/archive/2009/03/09/do-you-have-instant-file-initialization.aspx

  ---

  
  Clear Sky SQL
  My Blog[/url]