For some reason , those queries doesn't give me what is expected. it doesn't show up the spid as well.
Basically, if I try to open a new ssms session and execute below 2 queries, and If I query the DMVs , I should get , this particular spid, executed this batch and took 50MB. That's what I was expecting... Can we get such detail info?
create table emp
(c1 int identity,
c2 char (8000) default 'a' --- inserting 8k page
-- insert 50 MB data
insert into emp default values
go 6400 --50MB