1. What is the performance counters used to check memory utilization?
2. Which DMV's we can use to check perform counters?
3. Which DMFs can we use to check the complete command running in a session?
4. Which exe file can be used to trace the server actitivites?
5. Statistics - How to update on a particular table index?
6. Memory configuration.
If there is 16GB RAM, how can we make the server to use min 12 and max 14.
Lock pages in memory
7. How to improve the performance of Log Shipping?
8. How to move system dbs?
* TempDb
* master
9. Execution plans?
10.Why use DAC? How to connect?
11.Regular issues?
