The Multifunctioning DBA:

Disk Performance


August 16, 2012  3:08 PM

Easy way to find bytes per cluster on your disk

Posted by: Colin Smith
Administration, Data Files, Database Administration, Disk Performance

I recently learned a new windows command that is not the most intuitive, but it is nice.  I know that when I get a server and I am told that all my volumes are ready to go for SQL Server, I want to make sure that I have a 64K block. This command makes it easy to verify.   fsutil fsinfo...

January 20, 2010  5:00 PM


Posted by: Colin Smith
Disk Performance, IO, SAN, SQL Server

Just the other day I was asked to prove to a user that our SAN disk would be faster than the servers Local Internal Disk. Now I am no SAN Admin but I know that in most cases the Fiber attached SAN is going to be faster than the internal local 10,000 RPM drives in my servers. Well thanks to


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: