Best practices for Indexing Create index on columns that are frequently used for data retrieval or in filter conditions. For example in SELECT statement and WHERE clause or in ORDER BY , GROUP BY , and DISTINCT clauses. As i…
Use sys.dm_os_performance_counters to get your Buffer cache hit ratio and Page life expectancy counters