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(DAY, sd.crdate, GETDATE()) AS days_historyFROM sys.sysdatabases sdWHERE sd.[name] = 'tempdb' ;
No comments:
Post a Comment
Enter your comments here...