TempDB Free Space % Opsmgr Issue

less than 1 minute read

I just installed Opsmgr @ one of my clients. Using a default setup. One opsmgr server and one SQL 2005 server.

We put the TempDB on a different disk and configured the database as follow:


We set a initial fixed size with autogrowth none.

Problem now is that opsmgr is complaining about the free space of our tempDB:


The value is 0! That was not possible because we just give the TempDB 9gig. So we ran the following query to check ou TempDB size:

SELECT SUM(unallocated_extent_page_count) AS [free pages],

(SUM(unallocated_extent_page_count)*1.0/128) AS [free space in MB]

FROM sys.dm_db_file_space_usage;


As you can see we still have 8.9 Gig Free Space for our TempDB!!


So, we figured out that  if you put the TempDB on autogrowth non. The script that checks for DB free space is not working well! The strange thing is that that issue only occure with the TempDB! Opsmgr is not going to complain about the free space of other DB’s when you put them on autogrowth yes!


Finally, we put our TempDB on autogrowth:


And after a while everything was OK:






ps: THX Jeroen for assisting me!

Leave a comment