| Author |
 Topic  |
|
Kristen
Test
United Kingdom
22191 Posts |
 Posted - 06/18/2007 : 13:34:10
|
"I presume being one disk down will mean that the rest of the disks will have to pick up the slack"
Yeah, "And some ..." We have taken the view that an Array Rebuild takes so long we will have the database offline if that occurs ...
Kristen |
 |
|
|
coolerbob
Aged Yak Warrior
United Kingdom
841 Posts |
Posted - 06/25/2007 : 03:41:53
|
We've ordered a replacement server - arriving this week.
Then we saw this:
http://support.microsoft.com/kb/929240/
We're gonna apply that and if that fixes the problem...  |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 06/25/2007 : 08:13:15
|
Won't that have been superseded by SQL 2005 Service Pack 2 ?
Kristen |
|
|
|
coolerbob
Aged Yak Warrior
United Kingdom
841 Posts |
Posted - 06/25/2007 : 08:33:42
|
yeah, it was just to show the problem. The fix can be downloaded for either environment: SP1 or SP2
So we'll actually run this one http://support.microsoft.com/kb/936305
But I'm not holding out much hope. Just ran it on my chunky lab server and then ran Paul's stress tester and the result was the same: I/O errors
|
Edited by - coolerbob on 06/25/2007 08:35:20 |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 06/25/2007 : 08:59:02
|
| Sorry, I had assumed you already had SP2 installed. |
|
|
|
coolerbob
Aged Yak Warrior
United Kingdom
841 Posts |
Posted - 06/25/2007 : 09:29:00
|
| Er... Em... I do |
|
|
|
coolerbob
Aged Yak Warrior
United Kingdom
841 Posts |
Posted - 06/26/2007 : 03:56:01
|
quote:
Originally posted by coolerbob
yeah, it was just to show the problem. The fix can be downloaded for either environment: SP1 or SP2
So we'll actually run this one http://support.microsoft.com/kb/936305
But I'm not holding out much hope. Just ran it on my chunky lab server and then ran Paul's stress tester and the result was the same: I/O errors
Firstly,
Having said that, was I talking nonsense?
Does Paul's stress tester care what SQL Server hotfix I have installed for a known I/O problem?
Or is it a simulator that uses all of it's own code and doesn't even need SQL Server installed? In which case, the only way I could test whether the hotfix works is to roll it out...
Secondly,
Looking again at this http://support.microsoft.com/kb/929240/
How do you determine what MB/s limit to put in place for the checkpoint process? It uses 3MB as an example here... |
Edited by - coolerbob on 06/26/2007 04:40:09 |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
|
|
coolerbob
Aged Yak Warrior
United Kingdom
841 Posts |
Posted - 06/27/2007 : 12:17:37
|
Indeed!
Can you help with my 2nd question?
(Hopefully Paul will answer my first question soon)
|
|
|
|
paulrandal
Yak with Vast SQL Skills
USA
899 Posts |
Posted - 06/27/2007 : 12:38:53
|
For your first question - SQLIOSim is completely self-contained, so it can be run before SQL is installed.
Paul Randal
Principal Lead Program Manager, Microsoft SQL Server Core Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
http://blogs.msdn.com/sqlserverstorageengine/default.aspx |
|
|
|
Topic |
|
DBCC CHECKDB
