Hi,
Sometimes, in my application, when i browse a
record, it takes very fast 1/2 seconds but sometimes it
seems like hang there and take a very long time around 10
minutes to finish, is it because of clustering?

How to check and prevent from clustering?

thanks.

regards,

florence

probably not, unless your cluster is failing over from one node to another
as you issue the query, but even this is unlikely as

1) the application using this query would probably time out within 20
seconds or so
2) typically nodes failover within 2 minutes, although this can vary due to
the size of your transaction log.

I'd have a look at what you query is doing using profiler, and use sp_lock
to investigate locking.

It could also be related to the parameters in your query. The 1/2 second
query might only return 1 row, the 10 minute 1,000,000 or the 10 minute
query might involve different conditional logic than the 1/2 second query

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html


"florencelee" <florencelee (AT) visualsolutions (DOT) com.my> wrote