SQL Server - VisKey

There are so many short cuts one can quickly learn to recall their routine DBA activities.

Now today we have created SQL VisKey, where stroke 'V' - is - Key to find prospects to improve database performance.

V-Virtual Address Space

V-Virtual Log Files

V-Virtual Memory

V-Virtual File Stats

V-Vertical /Horizontal Table Partitioning.

V-View that can be converted to an indexed View.

Additionally,

Another important factor to justify this article is, we can create a separate SQL Login as 'v' and give permission only to these related DMVs.

Best Regards

Amit Vaid