摘要:
USE [master] ALTER DATABASE [DATABASE_NAME] SET RECOVERY SIMPLE WITH NO_WAIT ALTER DATABASE [DATABASE_NAME] SET RECOVERY SIMPLE GO USE [DATABASE_NAME] DECLARE @logname VARCHAR(150) SELECT @logname = N 阅读全文
摘要:
SELECT (total_elapsed_time / execution_count)/1000 N'平均时间ms' ,total_elapsed_time/1000 N'总花费时间ms' ,total_worker_time/1000 N'所用的CPU总时间ms' ,total_physical_reads N'物理读取总次数' ,total_logical_reads/execution... 阅读全文