Exam for Tuning & Tracing
For Beginners
- How to fetch records quickly from a table?
- Any two specific configuration settings to improve performance?
- What are the core events to capture while tracing?
- Name of the Native tool to trace?
- Name of the Interface to Create Job of Index Maintenance?
- Name of DBCC command to look at Logspace for all databases?
- Name of DMV to look at number of Virtual Log files for all databases?
- Which option is better Client Side Tracing or Server Side Tracing?
Additionally,
Track Version / Latest Update
https://learn.microsoft.com/en-us/troubleshoot/sql/releases/download-and-install-latest-updates
Tips and Tricks - ETL Package
Best Regards
T. Amit Vaid S.
No comments:
Post a Comment