as i watched your video you explain about physical read but values that you show use is " physical reads: 0 " and "read-ahead reads 170389". what do you mean about both values is read-ahead reads is physical read values ? please correct me if i miss understand. @Amit
Hi Amit, my table ABC has Reserved = 28GB Data = 15GB Indexsize = 13 GB Unused = 59MB When I ran your query it shows top table ABC in memory 23 GB, according to your theory size of the table is just 'Data' or including index?
Gr88 learning Sir, Thank you for sharing and keep sharing such live Troubleshooting on Production Server.. #bow
Amit - This one is really helpful and good insight !!
as i watched your video you explain about physical read but values that you show use is " physical reads: 0 " and "read-ahead reads 170389". what do you mean about both values is read-ahead reads is physical read values ? please correct me if i miss understand. @Amit
Hi Amit, my table ABC has
Reserved = 28GB
Data = 15GB
Indexsize = 13 GB
Unused = 59MB
When I ran your query it shows top table ABC in memory 23 GB, according to your theory size of the table is just 'Data' or including index?
Yaa, I like it and enjoy it too. I hope you will make more tutorials like this so that we could learn. I need scripts. How can I find it?
few members might have observed servername, login_name and db_name in earlier uploaded version ;)
First View