DB Size History

Schedule this to run weekly or monthly, and give yourself quick access to patterns in your databases' growth. This stored procedure stores snapshots of database size information at the time you run it, either for all your databases or just the one from which you execute it.

SCRIPT: DB Size History

PKzvR uspLogDBSize.sqlUT
ZX`{X`zX`uxY{H{%V00ѭC6{"(uf/]LMAI}!sѤ7﬏0/l-9z*O~_)(٤He=h#6[:@wARu˜LmNl(TXR_&!]OMHvn	6w0:yu9r2t,Őf;b3baƑ$;.]0h0u͊k\Mmk\#f:Z=è}=t|6nX\W
mu
/v
R]El)L(`0eHP<+&%Jplƴwx^D4מH߹Dˠ9 JIg9wkp:.Iʮ&wf_^sͲPquM|WiAKYҐ,6%i1RyɽŠ[nL3"ē ¾[1]r^Ayes(Lܯ+P_a.HfVmgPϕXRj4=8iM82=Ȋ\
|6/`h%ILptL惻޼s[	S=f=աMI-^eX7DfSzSgL5W[|mIJ-?0WGu1BX␃Mv5OW0_ȃxC5o;ܤPBP
D@hq򱯘=!snӁ3M97Utks")!++KZ㌑	/_4뙙DPT-ȝaGb6ʡJrG558d+^$7YRnGwN~j>ME e4z^04:8$4JܫVhU*}`!ߓcXj$~z@U#۳_g$O?,"Fr`.LV[5L4TQRT
ycI]GQ	ܬ+FSCeb	Sctc4`d+ZnLY;$Q"Hu9kf6qS:~?RnRGDG1>
uJ~ib~Xk|"Ϭ&ԲaEZqw̓ZxݙPCĽZ
9/	q5/- ^{qdXɏU> utE|D\#cإqCTBqU^>!{*+N1zFZ/DW܄Vqd=:rY%q0TSxΦSkO><(NMuq!g{8z"V r{{pp*:I	v
PK
PKzvR __MACOSX/._uspLogDBSize.sqlUT
ZX`{X`X`uxc`cg`b`MLVVP'100@>-cHHhd,BSg`OK,(II(qKOKwR59%ũ))%P{
B]njI"PMU|gIjnhqjQHbz1X}#d`0Ǣ'1)5'>%Ǩ04$9)$ȼ0<$M$]D`V+f : '`ԁPhz-ϲhݳﻵN
?\_1ykڛFjoWU-Uȗ	y^.?=fڂ^5=s|bx_PKuUKPK}<4 DBSizeDashboard2008.rdlUT
KX`uxiʶ(}8ܻhsjսHҊ_ޠQz_@L5*]r3"fOg㹕'N~XoaN>'
8~?ׇY1<-9F$4h fxW/o˴þ;$`9r4+Om-Մ`V+8)pgp:㭩d>AKϵc^S&lbF7dڿKCaoB7 }k7'X2vLB30#DΩJ1&gk$
,r䉔Dׇw@KN(`>YZG!s.o༕l:S*6o$|[k[i&aIe!׉-kmC}?v-vs}W	j+Fx2]Ys\@obs/mhO;K׽wKEl,/hiq+kȬ[~Zi)Z@2dK?`+R-N&Y'กvw
8.SrK蓗+븝~7KG>*\)ca8Inۀ#z17/zוwZLt0N/\O國ݎ˅G^S貖Q<<;+Cg}ړʩxDQ]gs:ਝV.=4>9{y.8f:|Xrri_ppW%`}kzcGmjJW-=oŴߴ?g;>4v2yTuR5s/P6wBhk~7	OO7Жmi}Rtrٱn
adKl4Bqզ4s-Tn><%uKM"ğ|=<'(>Hgړܛcv߻k-toW7ail\fga
Nj=+rM͞xQ;|~硆Ze,vTô`Kcu+Sm1OϏ$4
ʇ“kǕ|ʫ:|EW΃{Spx::Π@8}Çʀ\}_
7{ׇs_W緳X|yp)75pOUĶiB}JKdG/6Cwg#M3ЌKܫM`ZKb׉w`r
	`CKW9p9s뼡w9"YǫoI<^S|ѫqnjKyӗ%]qB]Χyv
w6リ4;s{;`=v < ~WP^Z[`OV]CT^ڿh**AVUVUjVXi@ͭRJ71-jb[#RkŶLno]OhieT/TY=ݍFM[IqhSguێ}Zt;oވѡ=(!ӷ #d9]{DW 7}~`[M<mc(S{9رK8;!gYpMSeǖN/ߋ =;$H/LG5ϣx#oML~x+"}8.m4O{>\|u3<2Sn'\7X[-+ǷNjŧ"!<8 jhX?V6{aP\:oq!S#ѣZ]Uؕ~ eZK@7K NH$M; " 3h{gT] }&&Mo_ o~$:Aig0,+*?4҉Ni"YJx7+uF8RO|1 }ȩ#}Mw-sGsl==x竫9~q]=<;/FvD}Fߎo#?DXC`,~Ԋ$Ϝ-16GB!={E?-6a7][DŽd>ZZ|bCAn3]gX]{ql@M?X⟿v3h]ŧ4Z ޲Xo?:ϔEJGbҴ]Ƨ4m?QK2{,z#kgXvc-{ՖgMbߕyp"U#0;Kprt}Tվ~%ǭro0~^|ӱy]يӂP{`1?E2n{@7fPs\&jIj!}ɷ7¹5xv`S $$'eYxRT+qt#6~XؾFd ݯ~㷉/\vYxTkw;gsQ=Owda=vd8 !?.p{j{"4굷egȿepgM οmHF[_iןӷ_9{ ~}yЯu'|4ܴe T"RToStbş{{iSA+ /f29\/揉W^T~qCP_LeT^)zr1?K5\fLt:r]~3;wuoӝVRmϭC4y덟qNy&!3Vι wޝ~TF dR/-Rq9i^j2kkT~/o,/]tyT~/ TzR+_!TerH_/B9^]fr3{n8*?TLfv\| psXYv<݊_aq>x}/dTY[S{x^zy\lN8:iviVӴKE`ۮE|N͞۷^ ^8|wz2<7DV|0Tג&$q+yixz'ꒆumD@.tmr͵. 8i8 Yi'̂5ǧ-==E"o=Vwd2=@GCGIq wHpoo\ܕۧ"[#X칙t6q~q2/?&ũ]OЏ "cqLgAG7眉_G^g/'/$RКiqzHvO[`˹̕Tѻۙ}SWWW2)]Gt˽\]'oNyق;VrЊs9=|}Gv=f"0}V]cXQ05 +f )n*\\ӊz)OzŶ> > u{Mvі9n;n+ghx[d-wTk^|8߈E"a nrfEOك;z79}aǫIYl#s+t:ƚ-ۃqݦzZjvQT7FU`RP_kv4;5إ/:VWC[tvn)Z^N2 ?{%xGɝ\Z@+(Ch%]8u|:wi{>F7?yd ,HtQߟ\YE$X[;Cpuje{Uw>3|$;|iE$uZ.uWo.8!N5oue8WmkEg겎<*| vup钷u;:|-<˟SŻMcito.wTΌ'lϨՓhnrݰh/Gq]g -:U)6]]4\a«^WzG}A.u\Y%Z'=d4u;)t$yDފGQ'T~(Ͼηq*=3-7OpZ S{ל=QYlY[i㧀oDv-rIjπ/^nez˻pGG'aJR x(~Վgu^+"[RnvM'/-=#7]˷bͽu\Cs `^:,^ >7Z'jD\ ub=sEDClxMq.n?n.(&3k%f?gr\PIPHooWxBק$-(&WH#=ߧt(<}_zaoWg r5!eA^qs_/-;_{5ꧢY.v? ּMXo;CzkSiҦ+[olOf$bɍ_*<unHV+9/v|I}~5>auݬah]յ޿ׯ4B7{Nפt˝p(NWl~IӍkgUY]KHfoϋ?Z|W.]_VN \y.mI oZ{1rfse6:gn/f7//Mҹ8(ۙrޣ0ʥ GRήUz}&yΤ\Uy&<8lJ+_a_XF`ʍmџJy =Ny~r{rGn w>>؄P#u_y|-<>R^XG>k[gNR02ɝJe9=DE͢PS4(41t6n$AmsLRY9:麕`ZYcVb4jFqe]ˆ$FiE3 5?s|;W`W`f~g]dzy. |y}uyg߇Npy\b*f'aUA|"Za7'-Z%Ƚ(ZIN"rg+9_&qcO1}WduN82fK}k)O-UU XH㇠ 9YUu^ˏT`cE%ӲZw5ΰI*obvM8i'3Zuts!"v,>r?$ gLwCW{Z쬸i Xt%ʵmhnx7gҟޚyRZNIfyҶ(䢠 lpt4ևy\wla.; ~^U٥fY>uHQC``7n_G\zÇ* bg(~>4Gai] p{4A~s4ʬ>:Y*sW̭l̽=o%o/lexGدfp=|ڷB'L*HH-VvyΧWNR ti}gB@?`gk7PbOqbTD%٥ c3$~]}hWo_OܝA}m p-qk&sF} O㿄s/|:w bQ-~_j{W; c&M=+ͮ;vqSU@s'e;x`X F>UO~ljt>yU|^.?>vvŗkW[qn/VkKʍDVJyq'pԄ(AEwKdnl6ث9cysאZ\MHj7R6@t/A /Pw|Hr^rQ]._Tw׶d\wg*oTTޔ?4A^^g_|ƚ6^rhBB/(Gy$|GFR)Iy/R[LsmvpF g-ܝ\pO)> X%)7<}8iE>NqOR*:61 ajv .lǣ :/Ff\V/4^Q<>rX'r(|a/[^-齗ˁ~,?(7+neeׇʇ=9OGVȷy!7zD[ CqX^qTIͷtT{ŷM-% DESt.BRr:_Tjq/֟ϥ tO~>4X'\(e~~[Kfzf簍,r\_z#/"T|~>j.]#ֱKK'v(Y>XqXOv!(]Lu]s 7,MY8l4Uٻ?,J~LvۧQ GPWץDKgP}O8Os;*99L x$Ŷ~8Ď /{bN7 =&ɘQYw1˟=5rdRCOL3Uq{cDAfN-YmuK-3g!V49k.kfn`͵spj];y(j[](}nx=~=p+f57q2[9sssf]Mj]U+sСp]㒗-U_Ta,ejjn9:wwNv6ѳSba yG+^W[tkoa\'"mr͈9MD$4\zUaಉJ|tMQ2A)_ڄVYm׫0iclç>S{^T6P/?ѕ؆ u :2T# [/Zg`~r2Q W-%tm5']>瓞d蹩.b46$43Gs ߕj#?|> nSW31%OJ<ʓ?(JI)yyu^rpIɓIzɕ+%OJ7O{/\)yRJzɕȕ'%Oޛ''#Wrm\)yR$%WWJ!FjnkPRnI5[zöH"7$z# IZ'Ws qo6Γ8>ˇ! 9{8N8\5woGp61"FT;!fdEPbQ\X)33DJf@|-k<4ن0ܗHe#,h568# a.$N.xӯGXlCFu e؟jwD9h>Iז>Z]̛S@uNEXo7zhx 'q*/vm# "\"pϨ@K"qjj*.2E dAq! /aG0i #A D(dT4w̰?l+u-s,dIJz!jz5XCj̰F\ƶLLI!᲋%lym|@ИV]s* D$bh j,aUFN9_2MYO#YhUW*#w"mDv7@YߝgkDUmU2:^s̈6K`lϩ׭D栾N;tkad ˷&ѣ^"YCm" eRʦKalfJxt4jP@J :$ U"c6D.fZtpͳa6gL.r )=R0 CVChOUWkq>J\z3oxlWiV ZHsRZ ɭA8ADkYg*hR5e+I2ĺ>r{۲z-6rXCYs;1ԻFvaϖ4'[]獞1#H!D;$:Mζ'1hpPEI &urj y]S 4nS5,E p*ۺ|q$ z&=iFBnJ[ȪM|6wO#ozts Y% h*'o ¹<щd#J.54j\cYMBXC{& QېϵUr5fpv~9N Fm3zC'*F kID4p:qʊኝj//4NQᡉ,':<+DW͎|ãte˙ڲif2G-[ 2 ca8ad*Wy2vD+Q(mM ">8 {sCrl q k=m{.@23n "S%XC 19'$f/Fn97J`ZCҪV`X-𦐻-?G5|LHXkxAVijZLʄU&3cP\a8ZY znT󙆷YC mf&G8u7-DLƓJъo7f94|RQY2+$A, x4\BgdSfX3H!BQP#/r& ILAq&e(xËnJlPjpB?ӾV;R)PjRPԴƲmolk}LC{w&a2YΕUj@b0G]yg)e|:KK P9Kh,%J)U"QN`YM8p%e|o;;P4bp9,$ j!1^ՌbFJqAo %q#IyzG-^j˅ldF-j1k3soP ŚxcrF%zn/z>[WCG- *5O4dK96mL5XW,뙟Ȃ?( jȱ8Jy w41oIlM}.FvbL@B[z`olVz~-;d9Vh ea c'̭+Ƌ8B9B/ %Ǖ7jl\H6e_ŀLZ׈[\5MQx{:v Ib7}ň%6‰pnmQ7Z>( Z9{}ڊ*:mQ`֦z:&m1SG4W336-Ǣ@WE32bݸ$Ճ/u{,:+- ̟PF6_|WҬRqC.L'MSH4>NN)5ӛ.Zڢ|H`&ymU d0i*2DَT6>ZTTkP׹>m5ֽ9Yfa(geDuHP ?!:w&sYthtL&HcK(&"ҝOf;0Kˑ6νdOY:@{R$xXA/Z-?s\*لd'|и  e\1ЂE~54r' N4 3sO\r^h)YV׆ܲ&Ci$tـZ|gjjR_!denDFIXkb-{<iDE2¬ۤ'(UhB{müFf76ªDXWL.ek0D:(å=ECݎ/CSӻkE!AY1iP* K')SMxVaoFY +T̠֐uTl P]-bUMN<P'*Ǣ~U޸/Hxjv lFrZNׯ9y MԌ~Kse3()@*Y5(@)0`u*x: muvQDE & ^4#h2L5BwD<:%uF(P)3'N&P4Ib,M_VvsZ^FsOj7C&kkj-n w SdVM4H `j4X/\5ޢV^ [6YatrNFơZb3'H6,VF 548U!Ti}B}gw:po ꅊDMtǭ$ˣpoV=9َQ`sÌm{8ǘ"Uzc$њ%;#Qo{ى$ÕiVy䝍)3:LF6`0HSkcNyjXITѼ0Niه 'ΟO S7-(UIb mgW1v&݃;xY5M,F`~*9:@UMs ?{}peU5T [kZ̍lCMr+5YM8(XV{´>T;t;A6hu]@7̝5>aXmCqiq޶jXNzIoQ*c6@lyAّ/:J\{ c& ɃVd0w +1b˱NM Vi1AoA)i nz wQBo5gUzjjʽ)kK՟ ɅEcdE 40Z /dfF^!/9j+3gܣmLr]'X+gDr/y tKtD*B=3Mgp&銌Nx[- q!1aw]5Wb mvV<=jD9x{$ŭMlƍI :T^9Vk̦ /G+'{GRvklfmf|ćpM55_y;vqԠkt 7}0bpx $qߟ[+cCzi2L"Is2ȣhk1<^@m0ʦXEτ:TkՎKP ͰBa[Ň-<Mij"w4Y)9ʺhV'f9|h[a>c(k Uj3|TbhГFDPo/ pm1tzdr%E2}Zy3eQN!3f:e~.Zfm4A'dq)Xq< SF!v}f-D̻r͸9FL 1;V( I Ȧ pÔHT[g=J4FUc{ƸuYmR<hFhŀwx&\M"6 bӳM'ؠNrKِ8e1=JLp 64WkԑBg:)'v2YK_g .5j2RAj^ç s6Xd)fZF#g*7@W裺w \ˢ$=~؄G1Ti7+ aT:j4E|nb{JNxdsJEt&G[[%$<'(Uծ[S^Fcy= `x󐍶l~f,ņo#-o]L[b =FMi#gJLzQ5H6vZr`]wjL%\EʬlV?A?n*jLLnYk+做4noPw9  **~ni!lbQuJÙ}}7Yͅ'\rtpFG MɎq{*ۙuI ɶUoVfP[4iWx w9U56dBklǃeJ}B%-"yċF+ح>xo ֋.HroYsPpN -S$&S -n CP8K\Ǧb[;c 3 9- Iz_IY(VVF&B dLkb2c!CL qcf9ab֠`%E͔R,<0ĥuy8qKBmsUjQ52ҩؒ6 5d ]U!_#mXTjb̛n4yϺ(FdQhuL*Wj ߡC|(b-x YI,#'yI'm"=Z1 p2$cs/9[HM;JF@3\eR[է#20w!Czܣn! q:n5[6e8!*/BHxs6QsmBc^fn7vY 䔈T/GHKI@v MڣFk3,2}O!/Se˒4)7̩7YG0jBmg FLjB]gkZ95뱪ʞ+*@V'ދ0kȯ\ w y'[lU=i$9\u4bf^lAm.U$k9ީ1ze:k%|HP:!tüW듸W>QDOΪXEVf2ݐ<ǻMO[Hm{LR> 4m3Ƞ)T<MGEaZ# @QzRJ' E ՝ ;4mf:]onlx9ɒ[mPb)p8x#*rOm̆-:5lMm6@}M2ٔdYO6Jk:6:\%"'`c]luf0.rLq &>0x%2Gmŋ1.!զY1|P *mOpӱ÷ib= uyfbx2Pn^) I"徱ZP6Z adn -vI~.BE$E5(ܸ4m0:Y56lW[ȪͰ4a2X(ѣ!VR@ 'kÆAOy:[ǚu1uE4b hv*"w͢u lB~2d#9ϏHFLKJLx#]=2-HSlbf+Li% ]ou70Z]m\6N.Q$ܖ ' 77!_5O{SɩFbtmibY^Gy `|K=1˾PORJ"eCqC6}b+:+^zBwd^6:*&den,4nv]wN[l>Pn^ywlGZx~f_hoc1d{PxJ%M2\{`7O_)r>Φs^C+muV E\l+=eG Ys WV*z ˊa&ЂȲ!l/]ݝ.eUi8.`DspV2؏\}T2@ٽ}*ΌVCXł2r7v>]jkLcpk\ˢbv}8eKӦc&, _ гx)\ sJ޻\9>򑄹Iy˱s@MuH^pTPCfZ8Q[ ~o |l.ÍAphk`Єad;bh&*BYɅ[E[H+8:'zx?1#[<۲> W MPŹ}?