SQL 2k profiler

[SQLScholar]

Hey all,

I am really new to using profiler.

What i cant currently work out is that i get lots of

SQL: Batchstarting

but then i dont get a matching

SQL: BatchCompleted

So i cant see how long its duration was. On one query in about 15 for adding a new customer onto our database i get the end - but not for the other 14.

How can i see how long my queries are taking?

Many thanks

Dan

----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[SQLScholar]

Sorry i just realised something.

I may come back later with another question.

Sorry

Dan

----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------