sql server 查看某表每秒插入的速度

USE [库名]
GO
-- 查看某表每秒插入的速度
IF EXISTS(SELECT * FROM TEMPDB..SYSOBJECTS WHERE ID=OBJECT_ID('TEMPDB..#TMP'))
       BEGIN
              DROP TABLE #tmp
       END
CREATE TABLE #TMP(ID BIGINT)
DECLARE @DATE DATETIME ,@DATE1 DATETIME
DECLARE @I BIGINT ,@A BIGINT ,@B BIGINT
       SET @B= 1 SET @I =1 SET @A = 1
       SET @date =  CONVERT ( VARCHAR (25 ), GETDATE() , 121 )
WHILE(@B <=31)
       BEGIN
			SET @date =  CONVERT ( VARCHAR (25 ), GETDATE() , 121 )
			SELECT @I = MAX(ID) FROM [dbo].[表名] WITH (nolock)
			INSERT INTO #TMP VALUES (( @I-@A) /DATEDIFF( ss,@DATE1 ,@DATE))
			SET @A = @I
			SET @B =@B+1
			SET @DATE1 = @DATE
			WAITFOR DELAY '000:00:01'
       END

SELECT AVG(ID) 'AVG',MAX(ID) 'MAX',MIN(ID) 'MIN' FROM #TMP WHERE ID >0

SELECT * FROM  #TMP WHERE ID IS NOT NULL