时间戳

首页 > 解决方案 > sql server management studio 中的性能测试

sql - sql server management studio 中的性能测试

问题描述

如何在 sql server management studio 中插入用于性能测试的表的示例数据

标签： sqlsql-server

解决方案

要填充大表，您可以使用以下方法设置希望行数：

CREATE Table Persons
(
   Id int identity primary key,
   Name nvarchar(50),
   Country nvarchar(50)
)



Declare @Id int
set nocount on; 
declare @start datetime = getutcdate();  

declare @i int = 0;
Set @Id = 1

While @Id <= 120000
   Begin 
   Insert Into Persons values ('Name - ' + CAST(@Id as nvarchar(10)),
          'Country - ' + CAST(@Id as nvarchar(10)) + ' name')
   Print @Id
   Set @Id = @Id + 1
END

SELECT datediff(ms, @start, getutcdate());

此外，还可以使用SET STATISTICS TIME ON

SET STATISTICS TIME ON
SET STATISTICS IO ON 
GO
Declare @Id int
set nocount on;     

declare @i int = 0;
Set @Id = 1

While @Id <= 120000
   Begin 
   Insert Into Persons values ('Name - ' + CAST(@Id as nvarchar(10)),
          'Country - ' + CAST(@Id as nvarchar(10)) + ' name')
   Print @Id
   Set @Id = @Id + 1
END
SET STATISTICS IO OFF 
SET STATISTICS TIME OFF
GO

推荐阅读