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.