DaveWentzel.com            All Things Data

April 2008

SAN Controller Notes


Controller Cache
So, your SAN has a data cache and generally they aren't huge.  A few GB is standard.  And your SAN is hooked up to many different servers/applications.  So, what is the best controller cache configuration for (your) SQL Server? 

Master Limited Partnerships


KMP is an example Master Limited Partnership (MLP).  In this arrangement taxable profits and losses are distributed directly to unit holders.  So, you aren't getting taxed twice (at the corp level) like normal public company shareholders.  Unit holders receive return of capital which is not taxed directly but lowers the cost basis of the holding.