James Livingston uses linear regression to plot database growth over time:

Utilizing the equation for a line, instead of solving for y we will solve for x, where:

–xcorresponds to the day we will hit capacity based on current growth rate

–ycorresponds to drive capacity in GB

–mis the slope of our regression line, provided by the model vialm.coef_

–bis the intercept of the regression line, also provided by the model vialm.intercept_

Click through for an example. This is one of the areas where DBAs can gain a lot by learning a bit of data science.

Kevin Feasel

2019-04-30

Data Science, Python