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:

image

We set a initial fixed size with autogrowth none.

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

image

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;

image

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:

image

And after a while everything was OK:

 

image

Greetz,

Alkin

 

ps: THX Jeroen for assisting me!

Leave a comment