Darling999 Posted October 12, 2012 Report Posted October 12, 2012 Naa Tempdb.mdf 160 GB ayipoyindi, productions lo sampestunnaru eminaa idea untey cheppandi daani mottam matash cheyyali like oka 200-330mb ki tevaali as its temp DB kada??? Help
innovative Posted October 12, 2012 Report Posted October 12, 2012 try this ... [url="http://support.microsoft.com/default.aspx?scid=kb;en-us;307487"]http://support.microsoft.com/default.aspx?scid=kb;en-us;307487[/url] I'm not working as a SQL DBA ..
Darling999 Posted October 12, 2012 Author Report Posted October 12, 2012 neney chesinaa evvaru help cheyyatledu janaalu assalu[img]http://i42.tinypic.com/16h2sdu.jpg[/img]
Darling999 Posted October 12, 2012 Author Report Posted October 12, 2012 [quote name='innovative' timestamp='1350054291' post='1302617312'] try this ... [url="http://support.microsoft.com/default.aspx?scid=kb;en-us;307487"]http://support.micro...kb;en-us;307487[/url] I'm not working as a SQL DBA .. [/quote] I already did it yar.
innovative Posted October 12, 2012 Report Posted October 12, 2012 [quote name='DARLING...' timestamp='1350054365' post='1302617323'] I already did it yar. [/quote] Np
edisav_edava Posted October 12, 2012 Report Posted October 12, 2012 Do you have any other drives with spare space? As a temporary solution you could create an extra data file for tempDB which would then be populated by using a mixture of proportinal fill and round robin algorithms. It's not a long term solution, I'm only suggesting it to ensure you do not run out of space in case you cannot have downtime. What you need to do is to find the cause of the problem. Although restarting the service will give you headroom as TempDB is recreated upon startup. Out of curiosity is your TempDB presized? If not you may wish to pre-size it in order to reduce the amount of growing that will occur later. Turning on instant file initialization will reduce the impact of data file growths - there is a security risk associated with this though. Back to the question of why tempdb has grown so large:[list] [*]What is your biggest table, could it be due to an index rebuild or a sort operation that has been left in an open transaction? [*]Are you using row versioning? This could be in the form of DDL triggers or one of the snapshot isolation levels. If you have transactions left open from quite some time back the version store which is held in TempDB will not clear down. Eventually this will lead to all your space being consumed. [*]How many temp tables are open? [/list] I would definitely check for open transactions, unless you have some massive table this is likely to be the reason why space has not been cleared.
edisav_edava Posted October 12, 2012 Report Posted October 12, 2012 first make sure..ur the single user... make sure no transactions are happening... take a backup of tempdb... stop the sql server service... restart it ... tempdb is created again...with the initial size... if it doesnt ..restart ur server.
edisav_edava Posted October 12, 2012 Report Posted October 12, 2012 if even that doesnt work....pm me or post it here
Darling999 Posted October 12, 2012 Author Report Posted October 12, 2012 I shrinked the database to 200mb directly, as of now I am the only one user to this Server. And oka Question tempDb lo antha space undachaa 160GB shouldnot right? as it does not contain any other data other than cache data? clear me this one.
Darling999 Posted October 12, 2012 Author Report Posted October 12, 2012 [quote name='edisav_edava' timestamp='1350055441' post='1302617472'] oh already got it huh....ok [/quote] I shrinked the database to 200mb directly, as of now I am the only one user to this Server. And oka Question tempDb lo antha space undachaa 160GB shouldnot right? as it does not contain any other data other than cache data? clear me this one.
gundugadu Posted October 12, 2012 Report Posted October 12, 2012 [quote name='DARLING...' timestamp='1350054336' post='1302617320'] neney chesinaa evvaru help cheyyatledu janaalu assalu[img]http://i42.tinypic.com/16h2sdu.jpg[/img] [/quote] yela chesavo chepthe maku vupayoga paduthuidni vayya
Darling999 Posted October 12, 2012 Author Report Posted October 12, 2012 [quote name='gundugadu' timestamp='1350057479' post='1302617778'] yela chesavo chepthe maku vupayoga paduthuidni vayya [/quote] idgoo solution [color=#282828][font=helvetica, arial, sans-serif]direct ga database meedaki elli right clik and tasks--> shrink -> filegroups tarvatha select 2nd option in shrink action later give your target size to that. then ok job done. But verey databases meeda .mdf file ni cheseyappudu jagratta because main data antha dantloney untundi[/font][/color]
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
Recommended Posts