question

Joe_Hell avatar image
Joe_Hell 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
administrationtempdbdb-size
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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?
0 Likes 0 ·

1 Answer

· Write an Answer
ThomasRushton avatar image
ThomasRushton answered
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.
5 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

yeah, the link in the question mentions server activity as a poss cause.
0 Likes 0 ·
This is an ongoing issue. Rebooting sometimes temporarily solves it. Might be a blocking issue doing more reseach now.
0 Likes 0 ·
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.
0 Likes 0 ·
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
0 Likes 0 ·
It happens on multiple clients with multiples system admin accounts
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.