|
| |
| |
|
|
|
Da Notes -
70-028 - P
Personal notes on the MCDBA tests. These notes are from the various resources I used to pass the MCDBA exams including the MCDBA sample exams from Transcender. |
Passing Score: 680, Questions: 52, Time: 90 Minutes
|
Da Notes Index
|
|
|
Performance
Tuning
|
Max Worker Threads: Default is 255. If SQL needs more than this no. of threads, it will start sharing threads (thread pooling). For small numbers of users, less than 255 is better than default value.
Parallel Query Options (Max Degree of Parallelism, etc.,): When turned on, can allow all or a subset of processors in a multi-processor machine to be used for a query. Should be used with care, because it can have a detrimental affect on performance. Use when few users are connecting. Can be set through
EM.
Min Server Memory: Min. amount of memory that SQL will use on start up.
Min Memory Per Query: On large OLAP servers, this setting might be useful.
Max Server Memory: Sets max amount of memory that SQL will use.
Max Async IO: Default is 32. When you have an efficient disk subsystem using multiple channels, increasing this value may be beneficial.
Disk queue length in NT Performance monitor: Optimally, this value should be less than 2.
|
|
|
|
|
