Thanks Kevin!

johnzabroski (4/8/2010)

---

Just to be clear, does that mean you will post a benchmark confirming the 10x increase reported by the vendor? I can understand if the vendor has license...

johnzabroski (4/8/2010)

---

That strategy is working out well and giving us some head room to plan for our next round of servers where we can properly plan and size them with...

magarity kerns (4/8/2010)

---

Has anyone here tried SQL Server on something like the ram drives from Texas Memory Systems? They aren't persistent when the machine is off like SSD's...

The definitive answer is 512...

ian-707364 (4/8/2010)

---

I was talking about the cluster size for formatting. However, as I understand it, currently most drives physical cluster size are 512 bytes with some new drives at 4096...

Also, we will be posting up a revised version of the article minus the typo's, grammatical errors and formatting issues.

Alen,

i would like to see a test comparing SSD's with a MSA 70 full of RAID1 volumes instead of RAID10.

If I get the time and can free up an MSA...

Jonathan,

http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/SQLIOBasicsCh2.doc

A SQL Server database can be restored or attached on a system that has a smaller sector size. To help guarantee data integrity, the larger sector size should...

brad.c-774062 Since we do alot of large random IO there was no way a standard disk array could keep up with the SSD. We monitor every aspect of our IO...

I've never been big on MS Certs. MCM is a different beast all together though. Any of you guys work with a Cisco CCIE who didn't know what the hell...

I didn't see anyone mention

http://blog.sqlauthority.com/2007/03/27/sql-server-fix-error-701-there-is-insufficient-system-memory-to-run-this-query/

I've found setting your min/max memory size fixed this on the two 2005 servers I was having the same issue on. It also went away when...

in 7.0 and 2000 if you named a proc sp_ you got a trip to master to try and resolve the name. In 2005 that has changed a bit. Now...

Yep, Gail wins the timezone war! She is spot on too, as usual.

I am also surprised this article got the green light.

I hate it when I'm late to the...

Thanks!