In Profiler, this is given for clientProcessID: The process id of the application calling sql server. Does this mean, that a particular application, say excel would have the same clientprocessid...

I had used the std template(with hostname included). When i ran sp_databases, the trace shows it as two records; one record with duration, starttime, endtime,Reads & CPU and another record...

yes done that

😀

In that case, which is the best trace template (standard,TSQL etc) to capture all (or those which can be captured) queries.

yes, its default trace. But even "select" is not being captured( front end mostly only retrives and less updates)

Ok, will start as a new thread.

am insering the trace records into a table. The problem is there is nothing in the TextData field other than those run from the...

Is the default trace (which is in Log folder) also available in SQL 2000?

If so, then what is the equivalent of fn_trace_getinfo?

once again thanks for the info..

am poor in math:-D. Thanks for the calculation explanation.

Thanks for the query.

Present size of DB is around 940MB and the max limit is set to 1000MB(i.e. restricted growth to 1000MB). So what would happen on reaching the 1000MB?...

My HeartFelt Thanks to everyone.

I learnt a number of new things (server trace, Transaction, statements etc)..

Now I am clear that i dont need transactions, i need the number of...

so it maybe a background process...right?.. Also can I omit such records for my calculation, since they are not a transaction in strict sense.

Thanks....Thanks....Thanks.

Thats a great way of explaining. Now I understand. Its complicated to get the query's count(which query ran how many times).

Still having one doubt.. that fileds with NULL values.. how...

Why "clean up the textdata field"? The data from fn_trace_gettable has all the required parameters...but also has fields where there's nothing but NULL .. What is that NULL?

Yep, understand you Gail. Forums like these are Godsend (as long as its free 😀 🙂 )

Its just that i cant wait to see the results and its...

Still waiting for an reply... am near to the finish line..