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 |
|
SQLCode
Posting Yak Master
143 Posts |
 Posted - 2008-05-01 : 15:52:53
|
| We are gettin disk I/O erros with severity 823. From what I read it looks like it is hardware related errors. But the harware guys are pushing back on us.We use SQL enterprise 2000 and have gigs of data for a over 100 gig db.Can bad or no indexing cause the page to break? Can querying, inserting or any db functions cause this to happen?It appears most times when we try to DML the tables with huge data. But once it is invoked, it shows up haphazardly for small or big querries.Thanks for all the help. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-01 : 15:55:42
|
| Bad or no indexing would cause performance issues due to high IO.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-01 : 21:47:30
|
| If it's hardware problem, you should see errors in windows event logs. |
|
|
|
SQLCode
Posting Yak Master
143 Posts |
Posted - 2008-05-02 : 11:35:23
|
| Thanks for the insight. I see the errors in Event viewer. Also, there are indexing issues that I am trying to resolve. It can make it slower, yes. But can it cause I/O errors?Also, tempdb growth takes forever sometimes. What can I do to prevent these? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-03 : 12:55:49
|
| Shouldn't cause i/o error. In fact i/o error may cause slowness. |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2008-05-07 : 11:21:04
|
| Most raid adaptors will have software which allows you to see the status of the drives / arrays your system is connected to. They are not alwasy correct tho, I had a scsi disk die and the only evidence was sql freaking out, everything else worked normally.I would make your hardware guys check whatever raid software you have. And if posible try another storage device.My favorite utility for testing drives is the Ontrack Data Advisor. |
|
|
|
|
|
|
I/O errors