in past i had a problem of that query been executed for 7 days. i couldnt find any solution. so i created again new database with indexes.
Now i am running a simple query:
query has been executing from last 26 hours. I really don't understand what to do please help
Autogrow of database1_log file in database database1 took 1010871 milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file
- Datafile - 40gb and log file - 50 gb autogrowth by 10%
Guys i still have the same problem.....please any one can help me
Autogrow of file 'database1.log' in database 'database' took 79342 milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.