Da Notes - 70-029 - W

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: 693, Questions: 49,  Time: 150 Min.

Da Notes Index 

[ 70-029 - A ] [ 70-029 - B ] [ 70-029 - C ] [ 70-029 - D ] [ 70-029 - E ] [ 70-029 - F ] [ 70-029 - H ] [ 70-029 - I ] [ 70-029 - J ] [ 70-029 - K ] [ 70-029 - L ] [ 70-029 - M ] [ 70-029 - N ] [ 70-029 - O ] [ 70-029 - P ] [ 70-029 - Q ] [ 70-029 - R ] [ 70-029 - S ] [ 70-029 - T ] [ 70-029 - U ] [ 70-029 - V ] [ 70-029 - W ]

With Check option

WITH CHECK OPTION - Changes to specific subsets of data only are verified.  Also see views

WIN NT Performance Monitor

Sqlserver RAM - if < MAX Server memory then to much memory configured for sqlserver

Buffer cache hit ratio = % pages in cache vs disk read - if < 90% need more memory

Free buffers - if only a few available - need more memory

Processor: % Processor time - if cpu > 80-90 % - need processor

System: Processor queue length - If threads > 2 - need processor