SELECT SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1,
((CASE qs.statement_end_offset
WHEN -1 THEN DATALENGTH(qt.TEXT)
ELSE qs.statement_end_offset
END - qs.statement_start_offset)/2)+1) request,
qs.execution_count,
qs.total_logical_reads, qs.last_logical_reads,
qs.total_logical_writes, qs.last_logical_writes,
qs.total_worker_time,
qs.last_worker_time,
qs.total_elapsed_time/1000000 total_elapsed_time_in_S,
qs.last_elapsed_time/1000000 last_elapsed_time_in_S,
qs.last_execution_time,
qp.query_plan
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) qt
CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp
where SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1,
((CASE qs.statement_end_offset
WHEN -1 THEN DATALENGTH(qt.TEXT)
ELSE qs.statement_end_offset
END - qs.statement_start_offset)/2)+1) like '%table_name%'
ORDER BY qs.total_worker_time DESC -- CPU time

INSERT [dbo].[table_name] VALUES(@Param000004,@Param000005,@Param000006,@Param000007,@Param000008)

SELECT Ins.* FROM
(

	SELECT [Transaction Id], [Begin Time], SUSER_SNAME ([Transaction SID]) AS [User], [Transaction Name]
	FROM fn_dblog (NULL, NULL)
	WHERE [Transaction Name] like N'%INSERT%'
) Ins
CROSS APPLY fn_dblog (NULL, NULL) Lg
CROSS JOIN (VALUES('dbo.T')) TableName(TableName) --МЕНЯТЬ ТУТ
CROSS APPLY (SELECT OBJECT_ID(TableName) TableID) TableID
WHERE Lg.[Transaction ID]=Ins.[Transaction ID]
	AND 
	(
		Lg.[Lock Information] LIKE '%:'+CAST(TableID AS VARCHAR)+':%'
		OR 
		AllocUnitName LIKE TableName+'%'
	)

SELECT last_user_update
FROM sys.dm_db_index_usage_stats --сработает только если у таблы есть индекс
WHERE object_id=OBJECT_ID('dbo.table','U')

insert into SISTO_2008.db1.dbo.t(id)...