Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am working on a code performance test project.

Let me first describe the enviorment: MsSql Server, Ria Service

The automation test runs a big set of Test cases in midnight where have minimum network traffic or CPU usage on the server.

The tests will calls the Ria Service and the Ria Service will make calls to the database to do same operation repeatedly for couples times.

The performance metric is measured using Sql Profiling Trace, so we got all sql calls that made within each test and we can associates each of them.

I notice sometime a same SQL calls in a test its performance will suddenly jump up.

i.e. An INSERT operation of a test, usually is around 0.807 ms and its jumps to 200ms.

I wonder is this a normal behavior? Say there is no environment impacts to the test...

share|improve this question
up vote 1 down vote accepted

It could be blocked by another process, it could have forced an autogrow, something else may have taken the CPU's attention, data may have changed affecting cardinality, the plan could have been flushed, who knows?

Basically, yes, the same query can behave differently at different times due to a variety of environmental factors, both inside SQL Server and external.

share|improve this answer
:( Oh well, I guess I will ignore those data. It is so difficult to do analyze when there is random jump in the data.... – King Chan Aug 15 '13 at 19:12

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.