September 29, 2016 at 2:12 pm
Can any one tell if there is a procedure to monitor tempdb periodically like in a job and alert the team when it fills up 85% of the tempdb fixed amount files.I have data files set autogrowth None.
September 29, 2016 at 4:32 pm
You can use my script here: https://spaghettidba.com/2014/09/05/database-free-space-monitoring-the-right-way/
It can be used in a SQL Agent job step, scheduled to run every 5 minutes (or whichever interval is appropriate for you) and send an email to you if the threshold is exceeded.
In the script I linked, the space available threshold is set at 20 (toward the end of the script): you can set it at 15 if that works for you, but be advised that 20% is a well established best practice.
-- Gianluca Sartori
September 29, 2016 at 7:07 pm
Does this monitor % full of the data files since my each of 12 tempdb datafiles are set to fixed initial size 25gb and autogrowth none.
September 30, 2016 at 4:37 am
It groups by filegroup, sothe sum of all files in your case.
-- Gianluca Sartori
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply