Search This Blog

Friday, 16 January 2015

When was last tempdb cleared

Following query will help us to find when was tempdb cleared? Means when was last usage stats cleared? This will show how many days are passed when usage stats are cleared.

SELECT  DATEDIFF(DAYsd.crdateGETDATE()) AS days_historyFROM    sys.sysdatabases sdWHERE   sd.[name] 'tempdb' ;