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