May 21, 2003 at 12:36 am
Trying to create a trace to figure out how locks are used on the server. Use all events from "Locks" group and save about 15 columns on a local machine in a table.
Run it... Users start crying: VERY slow perfomance...
Processors use is about 30-50% depending on time of the day. The number of locking one process by another is about the same as without the trace.
What could be the cause? Network card? (Gigabit) Really need to trace locks during work hours.
May 22, 2003 at 12:44 am
Also noticed, that when running the trace locally or on network the %Processor time counter goes down from 50% to 30%, the average disk queue length is tiny, users cry 🙁
May 22, 2003 at 2:15 am
The event Lock:acquired along does all this (no matter locally or on net), events like Lock:timeout or Lock:deadlock work fine.
I really need column ObjectName or at least ObjectID to be traced, to find out what objects (tables, views) are used the most. ObjectID column is traced only when Lock:acquired event is on 🙁
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply