Quote Originally Posted by tabreaz
Table has only two rows with less then 1MB
I was facing a problem with truncate command in a application, so i created test table with 2 rows & truncate command on table takes more than 4 minutes
When you execute truncate, did you check the I/O on your disks.

I think there could be a problem here. when you do this, it is waiting for the checkpoint to happen locally where the I/O is preventing and DBWR is busy. There is also chance for the log buffer parallel write delay.