THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Tools » Storage   (RSS)
  • Performance impact: file fragmentation and SAN - Part VI

    A script to fragment a test file Well, this post won't cover any actual test results and is not specific to SAN. But in the spirit of full disclosure, I've attached the script I used to control the fragmentation level of the test files mentioned in this series of posts. The script is written in Perl, but can be easily done in any ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on December 30, 2008
  • Finding Disk Partition Offsets Made Easy

    There were discussions on disk misalignment on this site. See my previous post on “Performance Impact of Disk Misalignment”, and Kevin Kline’s blog on “How to Improve Application and Database Performance up to 40% in One Easy Step”   But thanks to Jimmy May's PASS 2008 presentation on the I/O performance impact of disk partition ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on November 24, 2008
  • Geek City: My New Favorite Tool - SQL Internals Viewer

    At least, I think it might become my new favorite tool.  J One of my readers created a tool to graphically display database storage internals, like allocation information, actual page contents, etc. This is just the tool I would have wanted to write if I ever got back to doing any programming. Here's what the author, Danny ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on July 19, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement