I'd like to stress test some of my SQL queries and find out about bad query plans and bottlenecks. I plan to fill some tables with random test data.
我想强调测试一些我的SQL查询,并找出错误的查询计划和瓶颈。我打算用随机测试数据填充一些表格。
Are there tools or a set of scripts available for this purpose, preferably for SQL Server?
是否有可用于此目的的工具或一组脚本,最好是SQL Server?
Thanks!
UPDATE: Sorry, didn't know these two question already existed:
更新:对不起,不知道这两个问题已经存在:
- Data generators for SQL server?
- Creating test data in a database
SQL服务器的数据生成器?
在数据库中创建测试数据
2 个解决方案
#1
1
This website will generate reams of customized data for you.
该网站将为您生成大量的自定义数据。
From that site:
从该网站:
Ever needed custom formatted sample / test data, like, bad? Well, that's the idea of the Data Generator. It's a free, open source script written in JavaScript, PHP and MySQL that lets you quickly generate large volumes of custom data in a variety of formats for use in testing software, populating databases, and scoring with girls.
曾经需要自定义格式化的样本/测试数据,比如坏?嗯,这就是数据生成器的想法。它是一个用JavaScript,PHP和MySQL编写的免费开源脚本,可让您快速生成各种格式的大量自定义数据,用于测试软件,填充数据库以及与女孩一起评分。
This site offers an online demo where you're welcome to tinker around to get a sense of what the script does, what features it offers and how it works. Then, once you've whet your appetite, there's a free, fully functional, GNU-licensed version available for download.
该网站提供在线演示,欢迎您随时修改脚本,了解脚本的功能,提供的功能以及工作原理。然后,一旦你满足了你的胃口,就可以下载一个免费的,功能齐全的GNU许可版本。
#2
0
I've use this data generator with success in the past - may not be big enough for your needs though.
我过去成功使用过这个数据生成器 - 可能不够大,无法满足您的需求。
#1
1
This website will generate reams of customized data for you.
该网站将为您生成大量的自定义数据。
From that site:
从该网站:
Ever needed custom formatted sample / test data, like, bad? Well, that's the idea of the Data Generator. It's a free, open source script written in JavaScript, PHP and MySQL that lets you quickly generate large volumes of custom data in a variety of formats for use in testing software, populating databases, and scoring with girls.
曾经需要自定义格式化的样本/测试数据,比如坏?嗯,这就是数据生成器的想法。它是一个用JavaScript,PHP和MySQL编写的免费开源脚本,可让您快速生成各种格式的大量自定义数据,用于测试软件,填充数据库以及与女孩一起评分。
This site offers an online demo where you're welcome to tinker around to get a sense of what the script does, what features it offers and how it works. Then, once you've whet your appetite, there's a free, fully functional, GNU-licensed version available for download.
该网站提供在线演示,欢迎您随时修改脚本,了解脚本的功能,提供的功能以及工作原理。然后,一旦你满足了你的胃口,就可以下载一个免费的,功能齐全的GNU许可版本。
#2
0
I've use this data generator with success in the past - may not be big enough for your needs though.
我过去成功使用过这个数据生成器 - 可能不够大,无法满足您的需求。