SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 DBCC CHECKDB
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

Kristen
Test

United Kingdom
22403 Posts

Posted - 06/18/2007 :  13:34:10  Show Profile  Reply with Quote
"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
Go to Top of Page

coolerbob
Aged Yak Warrior

United Kingdom
841 Posts

Posted - 06/25/2007 :  03:41:53  Show Profile  Reply with Quote
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...
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 06/25/2007 :  08:13:15  Show Profile  Reply with Quote
Won't that have been superseded by SQL 2005 Service Pack 2 ?

Kristen
Go to Top of Page

coolerbob
Aged Yak Warrior

United Kingdom
841 Posts

Posted - 06/25/2007 :  08:33:42  Show Profile  Reply with Quote
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
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 06/25/2007 :  08:59:02  Show Profile  Reply with Quote
Sorry, I had assumed you already had SP2 installed.
Go to Top of Page

coolerbob
Aged Yak Warrior

United Kingdom
841 Posts

Posted - 06/25/2007 :  09:29:00  Show Profile  Reply with Quote
Er... Em... I do
Go to Top of Page

coolerbob
Aged Yak Warrior

United Kingdom
841 Posts

Posted - 06/26/2007 :  03:56:01  Show Profile  Reply with Quote
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
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 06/26/2007 :  04:51:00  Show Profile  Reply with Quote
"So we'll actually run this one http://support.microsoft.com/kb/936305"

Is it me, or is that a lot of post-SP2 issues??
Go to Top of Page

coolerbob
Aged Yak Warrior

United Kingdom
841 Posts

Posted - 06/27/2007 :  12:17:37  Show Profile  Reply with Quote
Indeed!
Can you help with my 2nd question?
(Hopefully Paul will answer my first question soon)
Go to Top of Page

paulrandal
Yak with Vast SQL Skills

USA
899 Posts

Posted - 06/27/2007 :  12:38:53  Show Profile  Visit paulrandal's Homepage  Reply with Quote
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
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.94 seconds. Powered By: Snitz Forums 2000