The SQL command to create this view and do the conversion would look like this: CREATE VIEW YOURSCHEMA.WORKAROUNDVIEW as select … , CONVERT ( TIMESTAMP , TSLTZ) AS DTCONVERTED from YOURSCHEMA.

You need to troubleshoot performance problems with SQL Server, and you need to do it now. You don't have time to track down a bunch of DMVs, figure out Extended Events, wrestle with terrible SSMS ...