MS SQL Server - unable to explain single user benchmark times not being consistent

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

unable to explain single user benchmark times not being consistent

the6campbells@hotmail.com

2006-03-06, 7:15 pm

SS2K Enterperise Server. Installed on different duals, quads as
dedicated database boxes. Base tables are classic star schema with
basic indexing but not heavily assisted with extra indexes, indexed
views etc.

Basic test approach is to run the same query N-times in succession via
OLE-DB or ODBC. Cannot explain why SQL Server times may fluctuate by
large amounts vs warm up and stay relatively constant. Again, this is a
single user serial execution of tests vs concurrency.

eg why might the 4th test drop back to very close to the first query
run time

Time = 76.707e
Time = 2.297e
Time = 2.172e
Time = 65.847e
Time = 2.219e

Other vendors solutions don't exhibit this pattern and not sure what is
going on that might cause flushing etc that would explain this type of
behaviour.

Suggestions.

Sponsored Links