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 |
|
kevindockerty
Starting Member
27 Posts |
 Posted - 2005-12-19 : 06:21:10
|
| We are having a problem with one of our production servers running SQL Server 2K/Windows Server 2003There are around 10 databases running on this instance - all was fine until a few days ago when everything suddenly started slowing down drastically. We cannot identify anything that has changed to cause this. ie. no changes to hardware or software.The problems we get include;Access queries to linked SQL tables time outVB programs talking to SQL tables timeout SQL server agent stops for no apparent reasonSQL logs report many occurances of"SQL Server has encountered 1 occurance of IO requests taking longer than...."and worryingly....."Stack signiture for the dump is 0x0000000"We also had some reported problems involving the raid controller BUT we think we have ruled out any hardware issue - by running diagnostics etc..Has anyone any idea of what is going on - its driving us mad ?Or some pointers as to where to start looking.regards,Kev |
|
|
bakerjon
Posting Yak Master
145 Posts |
Posted - 2005-12-19 : 09:30:41
|
| In my experience, when SQL Server says it can't write to the disks, it means there is a disk problem. I'd keep looking there. Can you post configuration of the Disk subsystem or RAID controller?Jon-Like a kidney stone, this too shall pass.http://www.sqljunkies.com/weblog/outerjoin |
 |
|
|
kevindockerty
Starting Member
27 Posts |
Posted - 2005-12-19 : 11:42:35
|
| The server is a Dell Poweredge 2650Dual processor / 2 gig Ram3 disks - raid 5The system log in 'Event viewer' shows this error periodically;"The device \device\scsi\mraid35x1 did not respond within the timeout period"let me know if you need any more |
|
|
|
bakerjon
Posting Yak Master
145 Posts |
Posted - 2005-12-19 : 17:41:43
|
| I'd look at the scsi device. You might try upgrading firmware, checking cable connections, etc. I know, it sounds trivial, but that's pretty much what it comes down to in these cases. A lot of times diagnostics will tell you everything looks fine, but then it ends up being a hardware or firmware issue.Jon-Like a kidney stone, this too shall pass.http://www.sqljunkies.com/weblog/outerjoin |
|
|
|
kevindockerty
Starting Member
27 Posts |
Posted - 2005-12-20 : 04:43:52
|
| The server is a Dell Poweredge 2650Dual processor / 2 gig Ram3 disks - raid 5The system log in 'Event viewer' shows this error periodically;"The device \device\scsi\mraid35x1 did not respond within the timeout period"let me know if you need any more |
|
|
|
kevindockerty
Starting Member
27 Posts |
Posted - 2005-12-20 : 04:51:24
|
| Upgraded firmware, checked and swapped cables - spoke with Dell and basically did everything they suggested. Your right about the diagnostics software - it reports everything is fine when clearly it is not !We think it may be down to an impending hard disk failure ?? any thoughts. |
|
|
|
|
|
|
|
|
SQL Server suddenly slows !