Seagate ST43401N/ND Installationsanleitung PDF herunterladen (Seite 94)

Writing Performance Scripts

• Write code to process result set(s)

• Name each transaction explicitly (for example, “

begin tran cust_update”)

to make it easier to identify in system procedures and tables

• For a stored procedure-based system, verify the parameters that make the

stored procedures work. If the parameters need to vary for a meaningful

test, add the necessary logic.

Volume is critical in performance simulation. A script roughly equivalent to an

application, running at the normal production volume for that application, is

usually better than a script functionally matched to an application, but running

at only half the volume.

If workload is based on client PCs issuing Transact-SQL, you can use

performance monitoring tools, available in the market, to capture data streams.

Drivers

In addition, you need drivers for these tasks:

• General Error Handling

• Deadlock Handling

• Result Handling

• Time Measurement

• Runtime Data Generation

General Error Handling

In the event of an error, you can either throw away the transaction and not count

it or, depending on the requirements of the test, restart the transaction and count

the entire response time.

Deadlock Handling

You have to resubmit deadlocked transactions to get a realistic time

measurement. You can count average response time with and without

deadlocks.

1 2 ... 89 90 91 92 93 94 95 96 97 98 99 ... 145 146

Keine Kommentare

Seagate ST43401N/ND Installationsanleitung Seite 94