Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ------------------------- BEGIN: Put FRAG3 data into new table
- BEGIN TRAN
- CREATE TABLE [DBO].[CopyOfFRAG3] (
- Primarykey int NOT NULL ,
- SomeData3 char(1000) NOT NULL )
- ALTER TABLE DBO.[CopyOfFRAG3]
- ADD CONSTRAINT PK_copyofFRAG3 PRIMARY KEY (Primarykey)
- insert into DBO.[CopyOfFRAG3]
- select * from [DBO].FRAG3
- COMMIT
- ------------------------- END: Put FRAG3 data into new table
- ----- BEGIN GET FRAGMENTATION INFORMATION
- EXEC GETINDEXINFO 'FRAG3'
- ----- END GET FRAGMENTATION INFORMATION
- ----- BEGIN GET FRAGMENTATION INFORMATION
- EXEC GETINDEXINFO 'copyofFRAG3'
- ----- END GET FRAGMENTATION INFORMATION
- ----- BEGIN CLEANBUFFER AND ALL WAIT FROM DATABASE AND MEASURE TIME
- EXEC CleanBufferAndWaitBeforeTest
- SET STATISTICS TIME ON
- Select Count_Big (*) From [DBO].copyofFRAG3 Where Primarykey >0 Option (MAxDop 1 )
- SET STATISTICS TIME OFF
- EXEC GetStatINFO
- ----- END CLEANBUFFER AND ALL WAIT FROM DATABASE AND MEASURE TIME
- ----- BEGIN CLEANBUFFER AND ALL WAIT FROM DATABASE AND MEASURE TIME
- EXEC CleanBufferAndWaitBeforeTest
- SET STATISTICS TIME ON
- Select Count_Big (*) From [DBO].[FRAG3] Where Primarykey >0 Option (MAxDop 1)
- SET STATISTICS TIME OFF
- EXEC GetStatINFO
- ----- END CLEANBUFFER AND ALL WAIT FROM DATABASE AND MEASURE TIME
- ---- collect Perfmon counter
- while (1=1)
- begin
- CheckPoint;
- Dbcc DropCleanBuffers;
- Select Count_Big (*) From [DBO].FRAG3 Where Primarykey >0 Option (MAxDop 1 )
- --- stop perfon after 10 sec
- --Disk Read Bytes/Sec (AVG)40656973
- end
- ---- Perfmon counter collected
- while (1=1)
- begin
- CheckPoint;
- Dbcc DropCleanBuffers;
- Select Count_Big (*) From [DBO].copyofFRAG3 Where Primarykey >0 Option (MAxDop 1 )
- --- stop perfon after 10 sec
- -- Disk Read Bytes/Sec (AVG)93310882
- end
- ------------------------- END FRAG3 data into new table
Add Comment
Please, Sign In to add comment