有方法对sql server数据库做压力测试吗？如果有，请大侠告知，谢谢！～

[hystream]

我现在想对sql server 2000数据库做压力测试，不知道是否有方法可以测试，
不知道LoadRunner7.51行不行，试了很久，好像不行。
请问：有方法对sql server数据库做压力测试吗？
如果有，请大侠告知，谢谢！～

[saucer]

see
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=VA.00004b22.027eb215%40compuserve.com

[saucer]

sorry, that article is too old, you use Database Hammer
from Microsoft SQL Server 2000 Resource Kit

http://www.sql-server-performance.com/resource_kit.asp

[pengdali]

测试过程：

环境：
PIII900 128M
win2000+sql server2000企业版
table name :t_data
CLUSTERED PRIMARY KEY :id
Rows:441000

语句1：
select * from t_data where
id in
(select top 10 id from t_data where id in
(select top 60000 id from t_data order by id asc)
order by id desc)
order by id asc

时间：390ms

语句2：
select * from t_data where
id in
(select top 10 id from t_data where id in
(select top 100000 id from t_data order by id asc)
order by id desc)
order by id asc

时间：4s

语句3：
select * from t_data where
id in
(select top 10 id from t_data where id in
(select top 150000 id from t_data order by id asc)
order by id desc)
order by id asc

时间：5s

语句4：
select * from t_data where
id in
(select top 10 id from t_data where id in
(select top 200000 id from t_data order by id asc)
order by id desc)
order by id asc

时间：6s

语句5：
select * from t_data where
id in
(select top 10 id from t_data where id in
(select top 250000 id from t_data order by id asc)
order by id desc)
order by id asc

时间：过了15m没有出来，中断

语句6：
select * from t_data where
id in
(select top 10 id from t_data where id in
(select top 300000 id from t_data order by id asc)
order by id desc)
order by id asc

时间：过了20m没有出来，中断

语句7：
select top 60000 id into #a from t_data order by id asc

create index ind_a_base_id on #a(id)

select * from t_data where
id in (select top 10 id from #a order by id desc)
order by id asc

时间：20s

语句8：
select top 100000 id into #a from t_data order by id asc

create index ind_a_base_id on #a(id)

select * from t_data where
id in (select top 10 id from #a order by id desc)
order by id asc

时间：21s

语句9：
select top 150000 id into #a from t_data order by id asc

create index ind_a_base_id on #a(id)

select * from t_data where
id in (select top 10 id from #a order by id desc)
order by id asc

时间：23s

语句10：
select top 200000 id into #a from t_data order by id asc

create index ind_a_base_id on #a(id)

select * from t_data where
id in (select top 10 id from #a order by id desc)
order by id asc

时间：24s

语句11：
select top 250000 id into #a from t_data order by id asc

create index ind_a_base_id on #a(id)

select * from t_data where
id in (select top 10 id from #a order by id desc)
order by id asc

时间：26s

语句12：
select top 300000 id into #a from t_data order by id asc

create index ind_a_base_id on #a(id)

select * from t_data where
id in (select top 10 id from #a order by id desc)
order by id asc

时间：28s

语句13：
select top 400000 id into #a from t_data order by id asc

create index ind_a_base_id on #a(id)

select * from t_data where
id in (select top 10 id from #a order by id desc)
order by id asc

时间：29s

语句14：
select * from t_data where
id in
(select top 10 id from t_data where id in
(select top 250000 id from t_data order by id asc)
order by id desc)
order by id asc

时间：过了25m没有出来，还没有中断