你如何在本地加载dev数据库（服务器）？ [英] How do you stress load dev database (server) locally?
问题描述
哇，这个标题立刻给了我你问的问题看起来主观，很可能会被关闭。
无论如何，经过一番搜索和阅读，我决定问一下。
来自我的问题：在优化现有数据库时首先要检查的问题是什么？，需要强调加载本地SQL Server dev数据库作为备份.bak文件。
我理解正确 paxdiablo的答案：DB（SQL）自动化压力/加载工具？没有通用的应力加载测试SQL工具独立于RDBMS？
SQL Server的压力测试加载工具是什么？
你对本地dev SQL Server的廉价和脏负载加载数据库？
更新：我有兴趣加载SQL Server 2000,2005,2008数据库
（没有大约2000年的线索）。
好，让我们把最终/真正的测试（到QA专家，DBA和系统管理员）放在一边，并将问题限制在应力加载的上下文中，以发现设计中存在明显的（令人沮丧的）缺陷，性能瓶颈。
没有通用的应力加载测试SQL工具独立于RDBMS。
/ p>那怎么可能呢？您可以隔离地对硬件子系统（例如SAN，网络）进行吞吐量基准测试，但数据库的性能在很大程度上取决于应用程序的访问模式，RDBMS的类型和硬件。
最好的办法是在代表性硬件平台 上加载测试您的应用程序连接到数据库 。有几种工具可以做到，包括 Ultimate版本的Microsoft Visual Studio 2010 a>。
Wow, this title gave me immediately "The question you're asking appears subjective and is likely to be closed."
Anyway, after some searching and reading, I decided to ask it.
Coming from my question: What are the first issues to check while optimizing an existing database?, which boiled down to necessity to stress load a local SQL Server dev database received as backup .bak file.
Did I understand correctly the answer by paxdiablo to question: "DB (SQL) automated stress/load tools?" that there is no general purpose stress loading testing SQL tools independent on RDBMS?
What are the stress test load-ing tools for SQL Server?
What are you doing for cheap and dirty stress loading of local dev SQL Server database?
Update: And I am interested in stress loading SQL Server 2000, 2005, 2008 databases
(having no clue about 2000).
OK, let's put aside final/real test (to QA speacialists, DBA and sysadmins) and confine the question in context of stress loading to find obvious (outrageous) flaws in design, performance bottlenecks.
You are correct.
There are no general purpose stress loading testing SQL tools independent of RDBMS.
And how could there be? You can throughput benchmark the hardware sub-systems in isolation (such as SAN, network), but the performance of your database depends very much on your access patterns of your application(s), the type of RDBMS, the hardware.
Your best bet is to load test your application connected to your database on a representative hardware platform. There are several tools that can do, including the Ultimate version of Microsoft Visual Studio 2010.
这篇关于你如何在本地加载dev数据库（服务器）？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
