you mean you want disk activity Like Logical reads,phyical reads ..
Try the Below Option
SET STATISTICS IO ON
-- Query here
SET STATISTICS IO OFF
The above Option Displays information about the amount of disk activity that is generated by Transact-SQL statements after the statements execute. This SET option produces text output