Interview Questions
1. What are the performance related benefits which are available in SQL Server enterprise edition?
There are some key enterprise edition only performance benefits across RAM, Parallelism, Query Plans and DISK I/O that will lead to better performance on high end systems.
1. Lock Pages in Memory
2. Advanced Scanning (aka Merry-go-round scan)
3. Larger Read Ahead Buffering on Storage Devices
4. Large Page Extensions
5. Parallel index Operations
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment