Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/71

Click to flip

71 Cards in this Set

  • Front
  • Back
8.00.193
SQL2000 RTM
8.00.534
SP2
8.00.760
SP3
8.00.384
SP1
ODBC provides what?
The transport layer for data transmission
Account Framework Format? characters and segments
9-66 characters
3-10 segments
What do you need in order to use the chart of accounts?
4 characters in segment 2!
Max storage size for the account framework and how to compute?
82 characters.
Just add 2 to the even segments and add 1 to the odd segments.
Perform Translation for character data?
CLEAR THIS BOX! may cause issues with password encryption
ANSI?
CLEAR ANSI CHECKBOXES!
Company ID format?
5 characters.
Why use template to install client workstations? (3 reasons)
1) Consistency between client installations
2) CD not necessary
3) reduced GUI time to start install on subsequent machines
What if passwords are not working?
Uncheck ANSI options in ODBC.
What if system password not working?
run that tricky SQL statement
Supported DPS platforms?
Win2k, WinNT Server and Pro, XP Professional
How do you identify computers in the process server environment?
with NAMES! no ip addresses
How does DPM choose DPS? 2things
1) CPU speed of DPS
2) number of jobs in DPS' queue
What if DPM goes offline? DPM is passive.
Load balancing cannot continue, however, jobs continue to process.
What machine gets DPS?
A dedicated machine
Multiprocessing and DPS?
If multiprocessing, then can run multiple DPSs
What data can be off-loaded to a DPS?
1) only global scripts
2) tasks not requiring user action
Server numbers and services?
Keep the number of servers in a service consistent.
Order of process server setup?
DPM->Process Server->Process Services
User classes (2 things)
1) apply to all companies
2) optional!
User class and rolling?
changes roll down and overwrite individual settings.
What if not specify class?
user can access all items
Major benefits of RAID?
1) performance
2) fault tolerance
Why is RAID 1 mirror better for logs?
Better write performance
Advantages of RAID 5 for data?
1) Faster reads that RAID 1
2) Less disk space than RAID 1
Cache Hit Ration at 87%!!!
It's okay...that's within acceptable range.
Lazy Writer?
Indicates aged pages are in the buffer. Having work in the disk queue like this indicates the disk is overburdened. Add more disks or get faster drives.
Bottleneck order priority?
1) Memory
2) Disk
3) Network
4) CPU
Guidline for optimizing SQL
let sql optimize itself!
What does MBS recommend to do to maximum server memory for sql?
Reduce by 5-15% tp reduce chance of other apps paging?
What does MBS recommend doing for minimum server memory for sql?
increase by 5%
Where are paths to dictionaries stored?
dynamics.set
what is in dex.ini? company, last odbc, last user
last company connected to, and last user
duinstall.log? what is it, what's in it?
installation log file. has sql server version amongst other things.
default db settings?
1) Auto Update Stats
2) Auto Create Stats
3) Torn Page Detection
how do you move db from raid 1 to raid 5?
detach and attach it
installerrors.txt
stores installation errors
Tuning
Memory Pages/Sec
Above 20 is a problem
Tuning
Memory Available Bytes
Low values should be investigated
Tuning
PhysicalDisk\DiskTime
Above 90% is a problem
Tuning
PhysicalDisk\CurrentDiskQueueLength
Above the number of spindles plus 2
Tuning
Network Interface\Bytes received
Drops indicate network interferance
Tuning
Network Interface\Bytes Sent
Drops indicate network interferance
Tuning
Network Interface\Bytes Total
Drops indicate network interferance
Tuning
Processor\Processor Time
80-90%+ is a problem
Tuning
Processor\Interrupts per sec
dramatic increase w/o increase in activity is a problem
Tuning
System Processor\Queue Length
Above 10 is a problem
Tuning
Network Interface\Bytes Sent
Drops indicate network interferance
Tuning
Network Interface\Bytes Total
Drops indicate network interferance
Tuning
Processor\Processor Time
80-90%+ is a problem
Tuning
Processor\Interrupts per sec
dramatic increase w/o increase in activity is a problem
Tuning
System Processor\Queue Length
Above 10 is a problem
Tuning
Dynamic Memory Allocation and SQL
is good....let this happen
Tuning
Boost SQLServer priority on NT
Make sql run higher than NT scheduler
15/24 instead of 7/15 single cpu/multi-cpu
Tuning
RAID 10?
combines mirroring and stip parity
Tuning
How many disks - RAID 1 vs RAID 5
RAID 1 = 2
RAID 5 = 3-32
Tuning
Selectivity
-estimate of percentage of rows returned
Tuning
SQLServer profiler
analyze workload
analyze if indexes are causing a bottleneck
Tuning
Cache HIT ratio < 80%
memory may be a bottleneck

....measures percent of instances where sprocs and triggers are accessed in cache memory
Tuning
SQLServer:Buffer Manager:Buffer Cache Hit Ratio
if low, then memory a bottlenect
Tuning
Memory Page Faults is high
Increase system memory
Eliminate non-critical system procs
Tuning
Process:Working Set is below the min for SQL
then sql is allocated more memory than it needs
SQLServer: Buffer Lazy Manager is active for extended intervals
disk subsystem may not be adequate
Avg Disk Queue Length > 2?
these mean CONGESTION! Increase number of drives/
DBCC DBREINDEX
Reindexes tables
DBCC CHECKDB
check database integrity
checks data pages and tables
Reconcile
compares corressponding data and deletes orphans
also makes sure corressponding data is the same and makes corrections if not so