I will be writing

this article in four parts because this topic is huge and amount of information

can be overwhelming for readers and for me also. So we will be exploring it

step by step.

1.                  

 DBCC

MemoryStatus

2.                  

 Using DMV

3.