Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-20 : 18:23:33
|
writes "In our application we have a table which contain a few rows (<30)with a high mutation level (insert and delete in the same transaction). This table is read a lot of times.
In the profiler I sometimes see for the reads column a number that exceeds 10000 on his table, the duration is in this case also significantly higher. Does this have anything to do with locking (polling?). Normal number of reads are are below 20 with a duration of 15 for this table. All reads can use an index on the primary key.
We use SQL 7 with sp2 on windows NT4 or windows2000."
|
|
|
|
|
|
profiler and locking