Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
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 |