Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tanu
Yak Posting Veteran
57 Posts |
 Posted - 2012-04-10 : 15:44:51
|
| The database is 38GB and the backup is set for every day at 12:00am. It is disk backup. Everything was fine but two days it started taking longer time. We have raid 5 in SAN environment. When I check the activity monitor on those two days I have seen that the 'BACKUP DATABASE' process is set to suspended with a huge wait time and the wait type is ASYNC_IO_COMPLETION.Every day it fininshes in 50 minutes but Monday night and Thursday night it takes 6 hours. I ran the profiler on those days but could not find anything. How do I trouble shoot this problem? Any suggestions? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tanu
Yak Posting Veteran
57 Posts |
Posted - 2012-04-10 : 16:24:20
|
| Sorry, I said it wrong. The main database and os run on RAID 0+1 on 15k RPM SAS disks |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-04-11 : 15:10:49
|
| Is there anything in the SQL error logs ?After Monday and Tuesday even the calendar says W T F .... |
|
|
|
|
|
|
Backup is taking longer time for 2 days