September 25, 2008 at 4:37 am
Hi Gurus,
My database is giving error for that last couple of days.I have some jobs which run at 12 am(night).I also scheduled a backup 30 mins after that.But some reason the application system freezes for 10-15 mins with no user being able to do anything.Then everythin becomes normal.
Seeing this happen I changed the back up time to 2 am but now the issue occurs at fews mins past 2 am .I am attaching the log file.Can some throw some light on this issue please.
September 25, 2008 at 4:54 am
Your disk is becoming a bottleneck:
SQL Server has encountered 16 occurrence(s) of I/O requests taking longer than 15 seconds to complete on ...
Several processes are struggeling for I/O completion on your D: disk, which is causing a digital traffic jam.
Since I don't know if D: is one physical disk (please reply), here are some general suggestions:
- make sure datafiles and logfiles and backupfiles are on a seperate disk (This is your problem)
- make sure you've implented a RAID solution for your data
- buy new hardware 😀
Wilfred
The best things in life are the simple things
September 25, 2008 at 5:31 am
Hi Wilfred,
yes d is one of the physical disk.i do have raid 5 with 2 logical partition,c & d.where else can i move it?also this is a new hardware.
September 25, 2008 at 7:10 am
So you have 1 raid 5 array with two logical partions c:\ and D:
Does this server have any other disk arrays...I assume not from your post but wanted to check.
I assume your backup is to disk is using the native sql backup.
I also assume that you database files are located on this one RAID5 array.
The database backup is accessing your database files and writing to the backup file all in the same process which ara all located on the same array and at the same time users are trying to access the db. The problem is an io bottleneck caused by this process. Some steps you might try to over come the problem
Add some addition disk arrays so you can atleast spread your databases' data and log files onto different drives. one extra for the backup files would be useful too.
You could also look at spliting the system databases from the user databases and possibly putting tempdb onto a drive of its own
have a look on this site for optimal hardware configurations for some other ideas and suggestions
Gethyn Elliswww.gethynellis.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply