http://sqlserver.ro/forums/16/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/6695.aspxWed, 04 Feb 2009 08:17:58 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:6695Diana0http://sqlserver.ro/forums/thread/6695.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=6695<P>Eu zic sa incepi cu <A href="http://technet.microsoft.com/en-us/library/cc966545.aspx">http://technet.microsoft.com/en-us/library/cc966545.aspx</A>. Cum este folosit tempdb la tine? Care ar fi dimensiunea optima?</P> <P>Tranzactiile "deschise" influenteaza dimensiunea fisierului log.</P>http://sqlserver.ro/forums/thread/6694.aspxWed, 04 Feb 2009 08:11:28 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:6694rremus0http://sqlserver.ro/forums/thread/6694.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=6694Ce se aplica la shrink LOG nu merge si la shrink DB. Opentran n-are nici o legatura cu marimea DB-ului.<br><br>Trebuie sa identifici rowset-ul care consuma spatiu. Potzi folosi <a href="http://msdn.microsoft.com/en-us/library/ms188776.aspx">sp_spaceused</a>.<br>Daca sp_spaceused nu e concludent uitate in tempdb.<a href="http://msdn.microsoft.com/en-us/library/ms175012.aspx">sys.partitions</a> (rows mare) si in tempdb.<a href="http://msdn.microsoft.com/en-us/library/ms187737.aspx">sys.dm_db_partition_stats</a> (page_count-uri mari). Ideea e sa gasesti un object_id care consuma mult spatiu, si de acolo sa continui investigarea (cine e obiectul, cine-l creeaza, de ce nu sterge din el etc etc). Tipic gasesti chestii gen #tabela_mea sau 'asp session state table' sau alte prostii asemanatoare.<br>Daca ai ghinion obiectul care consuma nu e un obiect real ci un worktable intern, atunci e mai greu de gasit vinovatul, dar mai intii sa vedem daca asta ecazul sau nu.<br>http://sqlserver.ro/forums/thread/6693.aspxWed, 04 Feb 2009 08:07:22 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:6693Alex0http://sqlserver.ro/forums/thread/6693.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=6693<P>imi da:</P> <P>database_name&nbsp;database_size&nbsp;unallocated space<BR>tempdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 29974.00 MB&nbsp;&nbsp;&nbsp; &nbsp;29916.80 MB</P> <P>reserved&nbsp;&nbsp;&nbsp;&nbsp; data&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;index_size&nbsp;&nbsp;&nbsp;&nbsp; unused<BR>57808 KB&nbsp;&nbsp;53616 KB&nbsp;&nbsp;&nbsp; 3048 KB&nbsp;&nbsp;&nbsp; 1144 KB</P> <P>alex.</P>http://sqlserver.ro/forums/thread/6692.aspxWed, 04 Feb 2009 08:03:01 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:6692ignatandrei0http://sqlserver.ro/forums/thread/6692.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=6692ce iti da la<br>EXEC tempdb..sp_spaceused <br>?<br>Dupa cite stiu, http://support.microsoft.com/default.aspx/kb/307487 , nu prea poti sa ii faci prea mare lucru ...<br>http://sqlserver.ro/forums/thread/6691.aspxWed, 04 Feb 2009 07:52:22 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:6691Alex0http://sqlserver.ro/forums/thread/6691.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=6691<P>salut, am o problema cu baza tempdb....are ~ 38 Gb si anume tempdev-ul nu logul</P> <P>am incercat sa-i fac shrink si degeaba nu vrea sa se micsoreze</P> <P>nu ii pot da momentan un restart de serviciu pt ca este pe serverul de productie</P> <P>cum ii pot micsora dimensiune?</P><FONT color=#0000ff size=2> <P>am rulat DBCC</FONT><FONT size=2> OPENTRAN si imi zice ca "DBCC OPENTRAN returns no transactions."</FONT></P> <P>multumesc</P> <P>alex.</P> <P>DbId&nbsp;FileId&nbsp;CurrentSize&nbsp;MinimumSize&nbsp;UsedPages&nbsp;EstimatedPages<BR>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3836576&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1024&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12128&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12120<BR>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 96&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 64&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 96&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 64</P>