I'm still curious about latency (avg sec per read and avg sec per write for each logical drive )

how many iops does sqlio show for 8k random reads and writes?...

How many cpu's?

Ok, here is a blind guess that probably isn't optimal for you but is maybe, just might be, could happen to be more optimal than the default.

Set...

Personally, I'd go for multiple drive letters if you expect only two instances.

I'll throw this out for public ridicule:

1 drive for the sql install (system dbs, sql errorlogs, etc)

1...

compare prod vs test perfmon counters for logical disk reads per sec, write per sec, seconds per write, seconds per read, and current disk queue length . Any discrepancies?...

Lee Crain (11/6/2012)

---

I'm doing my best to recreate a script I read written by Gila Monster (Gail Shaw) when she was recently assisting a DBA who had a database in...

Gpt partitioned lun on ibm ds4200 san. Windows sees it as such. the vol was created on a win 2k3 clus, detached, moved, re-attached on w2k8 then again...

Ok, i think it's related to: http://support.microsoft.com/kb/2581408

it seems the that bad data was written to the disk at the 2TB mark.

Why remains a mystery. I'll update this thread when...

ok, things just got wierd.

I went back one more page, and dbcc paged the contents:

.. valid data omitted ...

000000B6B9AC9E00: a9db97db 4008ae4b 97f0ffb9 a327c7e1 8ee50f2b ©Û?Û@.®K?ðÿ¹£'Çá?å.+

000000B6B9AC9E14: ...

Good idea, thanks.

Robert Davis (11/4/2012)

---

How quickly do you need to have it fixed? If there is enough time, I'd restore a backup to a test server and run repair there first to...

Simple recovery model...

CRAP!

ok, no page restore then.

My options just got limited.

option 1, restore full, restore diffs until i find the corruption, then reload in missing data. This...

http://www.sqlskills.com/blogs/kimberly/category/sp_helpindex-rewrites.aspx%5B/url%5D

Check out kimberly tripp's posts on duplicate indexes. You may have some dups that can be removed.

the same Sp can run multiple times simultaneously.

It might be this:

http://support.microsoft.com/kb/2543687

This bug is exposed when sql server resets connections after clients time out. so, apply the culm update to fix the issue, but it won't help...