DaveWentzel.com            All Things Data

Dave Wentzel's blog

Performance Problem Diagnosis Methodology

Performance Problem Diagnosis Methodology I'm often asked after solving some long-standing, difficult performance problem that couldn't be solved what methodology I use to diagnose and solve problems. My answer usually varies depending on the problem just solved, but that's not really the correct answer to the problem. The cop-out answer is simply "experience and a lot of study." The methodology I use is a lot like how a doctor diagnoses an illness...one of the reasons I love watching the show House on Fox.

CPI and Inflation


There's been a lot of talk lately about inflation...specifically about lowering the fed funds rate to get us out of this credit crisis.  Generally lowering the fed funds rate risks further inflation.  Some pundits have been saying that inflation is not an issue since the price of oil has radically fallen from $145 to $100, the price of gold has fallen, the buck has risen, etc.  I don't want to argue the merits of rate cuts...only to show that we should NOT rely on the CPI or government inflation data to determine what true inflation really is. 


I've been burned a few times on ETNs so I thought it prudent to research the subject a little more so I can lose less money next time. 


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. 


Call Ratio Backspread

The call ratio backspread is a new technique I'm using in this very volatile 2008 market.  You get the most profit by using this system while the market is heading downward...anticipating a reversal. 



Subscribe to RSS - Dave Wentzel's blog