Incorrect Syntax (4335426)

Collection 'Top 250 dm_exec_query_stats Entries' failed : Incorrect syntax near '.'. [102]
Collection 'Session List' failed : Incorrect syntax near '.'. [102]
Collection 'Long Running SQL' failed : 'sql_handle' is not a recognized table hints option. If it is intended as a parameter to a table-valued function, ensure that your database compatibility mode is set to 90. Incorrect syntax near the keyword 'and'. [321]
Collection 'Bottom 250 dm_exec_query_stats Entries' failed : Incorrect syntax near '.'. [102]
Collection 'Blocking' failed : Incorrect syntax near '.'. Incorrect syntax near '.'. Incorrect syntax near 'wt'. [102]
Action for alarm 'Memory - Page Life Expectancy' failed : Incorrect syntax near '.'. [102]
 

This is caused by the incompatibility between the SQL we use and compatibility level of tempdb

Run this SQL:

USE [master]
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'tempdb', @new_cmptlevel=xx GO

Where xx is 90 for SQL Server 2005, 100 for 2008 and 110 for 2012.