Describe how a database administrator can distinguish between normal and abnormal SQL Server activity.

What will be an ideal response?


To distinguish between normal and abnormal activity, the database administrator must understand how the system is expected to perform under normal operating loads. One way to measure system performance is to record a set of results -  called a baseline - using specific configuration values and a particular set of database activities that can be used as future comparison points.

Computer Science & Information Technology

You might also like to view...

High-speed registers for the temporary storage of values are found in …

A. the computers hard disk B. the computer's primary memory C. the accumulator D. the C++ program

Computer Science & Information Technology

Ink annotations are used during a slide show to emphasize information

Indicate whether the statement is true or false

Computer Science & Information Technology

A kernel consists of related program code organized into small units that are easy to understand and maintain. 

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

The rule that every statement should end with a semicolon is an example of a syntax rule.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology