November 2008 - Posts

• 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 Read More... Posted Monday, November 24, 2008 7:21 PM by Linchi Shea | 13 Comments Filed under: Performance, Scripts, Tools, Storage, Best Practices Attachment(s): find_offset.zip

• Where is HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer?

  For a SQL Server 2000 default instance, the registry keys and values under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer are absolutely critical to its functioning. So if someone tells you that the whole registry subtree underneath there Read More... Posted Thursday, November 13, 2008 12:16 AM by Linchi Shea | 2 Comments Filed under: Installation