This question is from a developer, so it might be a simpleminded.
We have a dev and prod sqlservers (2000) and I suspect the disk write times on the Prod server are quite slow. I've done the following t-sql tests
Test 1 : 10k inserts, takes 2 secs on Dev, 63 secs on Prod
if object_id('testD') is not null drop table testD create table testD (i integer) declare @i int set @i=1 while @i <= 10000 begin insert into testD (i) values (@i) set @i = @i+1 end
Test 2 : 5k deletes , no time on either server
delete from testD where i >= 5000
Test 3 : Nested Loop, 2 secs on Dev, 5 seecs on Prod
select count(A.i + B.i) from testD A , testD B
These tests are conducted out of hours and, I always get the same results. I'm a developer so my only access to the servers is through SQLServer. What conclusions, if any, can be drawn from these tests, and what sort of questions shuold I be asking the tech support section?