Intrebari generalehttp://sqlserver.ro/forums/16/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)Re: To SHRINK or not to SHRINKhttp://sqlserver.ro/forums/thread/7668.aspxSat, 10 Oct 2009 18:53:18 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7668cardasim0http://sqlserver.ro/forums/thread/7668.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7668Clar, retinut, nu "on a regular basis" <img src="http://sqlserver.ro/emoticons/emotion-1.gif" alt="Smile" /><br>Re: To SHRINK or not to SHRINKhttp://sqlserver.ro/forums/thread/7666.aspxFri, 09 Oct 2009 20:52:07 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7666Diana0http://sqlserver.ro/forums/thread/7666.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7666You're welcome... <br />Do not shrink on a regular basis... <br />Uneori probabil vei avea nevoie. De exemplu, vezi "punctul 8" din <br />http://www.sqlskills.com/BLOGS/KIMBERLY/category/Transaction-Log.aspx#p3Re: To SHRINK or not to SHRINKhttp://sqlserver.ro/forums/thread/7664.aspxFri, 09 Oct 2009 19:17:38 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7664cardasim0http://sqlserver.ro/forums/thread/7664.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7664Atunci e clar: not to SHRINK!<br><br>Din nou, multumesc, Diana.<br>Re: To SHRINK or not to SHRINKhttp://sqlserver.ro/forums/thread/7650.aspxThu, 08 Oct 2009 10:38:33 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7650Diana0http://sqlserver.ro/forums/thread/7650.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7650"Teoria" si ceva experienta proprie spun ca e bine sa te feresti sa faci "shrink on a regular basis". "Autoshrink" are asigurat un loc in categoria "evil". Argumentatii extra: <br />http://www.karaszi.com/SQLServer/info_dont_shrink.asp <br />http://technet.microsoft.com/en-us/magazine/2008.08.database.aspx?pr=blog <br />To SHRINK or not to SHRINKhttp://sqlserver.ro/forums/thread/7649.aspxThu, 08 Oct 2009 09:55:12 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7649cardasim0http://sqlserver.ro/forums/thread/7649.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7649Salutare,<br><br>Aplicatia la care lucrez foloseste o baza de date in care constant am 20 zile x 2.000.000 = 40.000.000 inregistrari.<br>In fiecare zi primesc 2.000.000 inregistrari noi si trebuie sa sterg 2.000.000 cele mai vechi.<br><br>Pentru asta am un task de mentenanta care ruleaza noaptea (cand sistemul e cam idle), task care pe scurt cuprinde urmatoarele:<br>- face niste UPDATE-uri<br>- DELETE cele 2.000.000 inregostrari<br>- verifica fagmentarea unor indecsi si ii recreeaza daca e cazul<br><br>Si acum inrebarea: din punct de vedere al performantei sistemului (nu a dimensiunii fisierelor bazei de date) are sens sa fac SHRINK la fisierele de date dupa toate aceste operatiuni? Ajuta sau dimpotriva?<br><br>Multumesc.<br>