asked
property size is not availalbe for database tempdb.
SQL SErver 2008 EE SP2 In SSMS RT click tempdb properties. property size is not available for database tempdb. select * FROM sys.allocation_units AS a --this query runs forever, so SMSS times out select * FROM sys.partitions AS p --this query runs forever, so SMSS times out Another link with a similar issue [
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/2b95ec25-7c23-4d5c-b5d5-aeea50ddc833][1] Any ideas? SELECT SUM(size)*1.0/128 AS [size in MB] FROM tempdb.sys.database_files this returns 1799.437500 [1]:
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/2b95ec25-7c23-4d5c-b5d5-aeea50ddc833
none of what you describe happens on my 2008 Std Edtion sp2 from my Microsoft SQL Server Management Studio v 10.50.2500.0. Have you tried different client and different server combinations? Does it happen across all of your enterprise?
The last time I saw this problem was when an operation was thrashing seven bells out of my TempDB, and the TLog was growing rapidly from it.
yeah, the link in the question mentions server activity as a poss cause.
You might want to just see what else is going on at the time that causes these issues - look for rogue transactions or those doing huge data manipulations.
If you dont have it already then get sp_whoisactive on your server (
http://sqlblog.com/files/folders/beta/entry36726.aspx) it may shed some light on what is taking place
