--backup of prices off ZEUS on 11-9 is placed on the d drive of SQ_QUOTESP101 --Preservation of this file is useful for use in tests at other stripe sizes --11/09/2002 11:51p 3,205,490,176 prices.bak -- the benchmark is set as the Veritas software default 132K -- script should be executed by a member of the sysadmin SQL Server system role declare @dt datetime select @dt = getdate() select @dt as [start: exec xp_cmdshell 'dir d:\sqlstripetest\prices.bak'] exec xp_cmdshell 'dir d:\sqlstripetest\prices.bak' select datediff(s,@dt, getdate()) as [execute duration in seconds] if db_id('sqlstripetest') is not null drop database sqlstripetest select @dt = getdate() select @dt as [start: restore database sqlstripetest from disk = 'd:\sqlstripetest\prices.bak'] restore database sqlstripetest from disk = 'd:\sqlstripetest\prices.bak' with recovery, move 'prices_Data' to 'F:\mssql\data\prices_Data.MDF', move 'prices_Log' to 'E:\mssql\Log\prices_Log.LDF', move 'prices_index' to 'f:\MSSQL\Data\prices_index.ndf' select datediff(s,@dt, getdate()) as [execute duration in seconds] select @dt = getdate() select @dt as [start: exec xp_cmdshell 'bcp sqlstripetest.dbo.p01 out f:\p01.txt -SSQ-QUOTESP101 -n -T -ef:\p01.bcperr'] --bcp a large table out exec xp_cmdshell 'bcp sqlstripetest.dbo.p01 out f:\p01.txt -SSQ-QUOTESP101 -n -T -ef:\p01_bcpout.err' select datediff(s,@dt, getdate()) as [execute duration in seconds] select @dt = getdate() truncate table sqlstripetest.dbo.p01 select @dt as [start: exec xp_cmdshell 'bcp sqlstripetest.dbo.p01 in f:\p01.txt -SSQ-QUOTESP101 -n -T -ef:\p01_bcpin.err'] --bcp table back in exec xp_cmdshell 'bcp sqlstripetest.dbo.p01 in f:\p01.txt -SSQ-QUOTESP101 -n -T -ef:\p01_bcpin.err' select datediff(s,@dt, getdate()) as [execute duration in seconds] select @dt = getdate() select @dt as [start: dbcc dbreindex('weekly')] dbcc dbreindex('weekly') select datediff(s,@dt, getdate()) as [execute duration in seconds]