Managing your Relativity environment

Question 1

What is considered a large workspace, and what does it often require more of?

Answer 1

over 500,000 records,
DBAs to add more indexes on any necessary SQL fields within the database

Question 2

When should an index be executed against a table in SQL?

Answer 2

afterhours, as the building of the index will lock the table it’s running against

Question 3

What are some examples of fields that an index can be run against for improvement?

Answer 3

fixed-length, Yes/No (Boolean), Decimal, Whole Number, or Date fields on the document table of a workspace database.

Question 4

T/F: Any manually created indexes carry over during workspace creation. Relativity performs a full backup restore operation and doesn’t contain any logic to delete indexes.

Answer 4

True

Question 5

What is considered a long running query, and what are some examples of such?

Answer 5

anything that takes longer than a couple of seconds to complete.
document list views, advances searches

Question 6

What tool in Rel can be used to identify and review long running queries?

Answer 6

History tab and AuditRecord table in each workspace (execution time and SQL queries can be seen here)w

Question 7

What can you do to help remediate a slow keyword search experience?

Answer 7

rebuild the full text index

Question 8

What is affected when a Full Text index is in progress?

Answer 8

keyword searches may come back incomplete as it builds, and ‘Contains’ serches will be incomplete.

Question 9

What can help to reduce a full backup execution time?

Answer 9

writing to fast storage, maintaining log file sizes, and including backup file compression

Question 10

What is a differential backup and how is it different than a full backup?

Answer 10

contains all data that has changed since the last full backup (base)
smaller and quicker than a full backup

Question 11

T/F: Differential backups provides point-in-time restore capabilities

Answer 11

FALSE

Question 12

What kind of backup can provide point-in-time restores or point-of-failure restores of databases?

Answer 12

Transactional log backups

Question 13

What controls transaction log maintenance?

Answer 13

recovery models

Question 14

What kind of model are default databases set to use?

Answer 14

Full recovery model

Question 15

What kind of model does Relativity support for all workspaces?

Answer 15

simple recovery model

Question 16

In addition to SQL backups, what else does Relativity suggest to take backups on regularly?

Answer 16

dtsearch and analytics index shares,
Relativity web server install directories,
native and image file shares

Question 17

What is the check database integrity task doing?

Answer 17

checks the allocation and structural integrity of all objects in a specified database.

Question 18

Database corruption is usually caused by __________.

Answer 18

the underlying storage

Question 19

What prevents the transaction log from growing and using more space?

Answer 19

SQL server automatically marks the inactive portion (completed transactions not used for recovery) for reuse after it is finished being backed up