http://blogs.msdn.com/sqlserverstorageengine/archive/2009/01/12/tempdb-monitoring-and-troubleshooting-out-of-space.aspxOne of the key challenges in TempDB is that it is a common resource for all applications running on an instance and any misbehaving application or rouge user command can take up all the space in TempDB bringing down other applications with it. In my discussionsenCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/sqlserverstorageengine/archive/2009/01/12/tempdb-monitoring-and-troubleshooting-out-of-space.aspx#9306672Mon, 12 Jan 2009 04:41:28 GMT91d46819-8472-40ad-a661-2c78acb4018c:9306672infoblog &raquo; TempDB Monitoring and Troubleshooting: Out of Space<p>PingBack from <a rel="nofollow" target="_new" href="http://blog.a-foton.ru/index.php/2009/01/12/tempdb-monitoring-and-troubleshooting-out-of-space/">http://blog.a-foton.ru/index.php/2009/01/12/tempdb-monitoring-and-troubleshooting-out-of-space/</a></p> http://blogs.msdn.com/sqlserverstorageengine/archive/2009/01/12/tempdb-monitoring-and-troubleshooting-out-of-space.aspx#9576860Thu, 30 Apr 2009 01:43:39 GMT91d46819-8472-40ad-a661-2c78acb4018c:9576860anoop207<p>tempdb is showing one strange behavior :</p> <p>data files are of size 10gb each if i see on sql server ,</p> <p>but if i see them on operating system file system they seems to be of 50GB each</p> <p>and no way to shrink them as for sql server they are of size only 10gb </p> <p>any cpmment ?</p> <p>sql 2005 sp3 on windows 2003</p> http://blogs.msdn.com/sqlserverstorageengine/archive/2009/01/12/tempdb-monitoring-and-troubleshooting-out-of-space.aspx#9578301Thu, 30 Apr 2009 07:18:27 GMT91d46819-8472-40ad-a661-2c78acb4018c:9578301Sunil Agarwal<p>are you sure you are looking at the file size or the allocated space? what command did you use? thakss</p> <p>This KB on shrink TempDB</p> <p><a rel="nofollow" target="_new" href="http://support.microsoft.com/kb/307487">http://support.microsoft.com/kb/307487</a></p> http://blogs.msdn.com/sqlserverstorageengine/archive/2009/01/12/tempdb-monitoring-and-troubleshooting-out-of-space.aspx#9623413Sat, 16 May 2009 21:07:25 GMT91d46819-8472-40ad-a661-2c78acb4018c:9623413SQLLion<p>Thank you for such valuable information.</p> <p>For more information about Monitoring and Optmizing tempdb, I can suggest you to click the below link.</p> <p><a rel="nofollow" target="_new" href="http://www.sqllion.com/2009/05/monitoring-tempdb-in-sql-server-2005/">http://www.sqllion.com/2009/05/monitoring-tempdb-in-sql-server-2005/</a></p>