<<x-no-archive: yes>>

I have an application that talks to Sybase via garden variety SQL.
The database is medium to large sized.

When I run a particular query, it usually takes about 60 seconds
to retrieve about 5000 rows. For the most part, its consistently
around 60 seconds. However, the *same* query occasionally can take
up to 20 min during various parts of the day. When I run sp_who,
I only see about 100 users connected but with only 4 or 5 users
doing selects or inserts.

Anyone have any ideas what's going on? Its weird.

Frank
+=========================================+
| Crossroads Technologies Inc. |
| Enterprise Java Engineering |
| Web: www.CrossroadsTech dot com |
| Email: fgreco @ crossroadstech dot com |
+=========================================+

"Frank D. Greco" wrote:
>
> <<x-no-archive: yes>>

Sorry, but that's not going to work.

> I have an application that talks to Sybase via garden variety SQL.
> The database is medium to large sized.
>
> When I run a particular query, it usually takes about 60 seconds
> to retrieve about 5000 rows. For the most part, its consistently
> around 60 seconds. However, the *same* query occasionally can take
> up to 20 min during various parts of the day. When I run sp_who,
> I only see about 100 users connected but with only 4 or 5 users
> doing selects or inserts.
>
> Anyone have any ideas what's going on? Its weird.

Assuming that by "Sybase" you mean a version of ASE, you
could look at the query's showplan to see what's going on.
It looks like it might be table scanning or there's some
resource contention going on (does sp_who show it as being
blocked when its slow?).

-am © 2003