SQL Profiler results question

[theJazzyBrain]

Deat CPians, I have a heavy duty database on SQL Server 2000. Every now and then I monitor the transactions applied against the database using SQL Profiler in order to spot the queries and SPs that use alot of CPU resources. Here are a few of many transactions that my question will be based on:

APPLICATION TEXTDATA DURATION STARTTIME READS WRITES CPU

.Net SqlClient Data Provider 1229250 1/3/2006 10:53:53 am 2080346 366 60811
Internet Information Services 618203 1/3/2006 10:54:38 am 61550 1 4016
.Net SqlClient Data Provider exec lc_getLatestIpById @mem_id = 267980 483 1/3/2006 11:26:44 am 4594 0 484

As you can see the second column displays the actual querry. I noticed the there are many requests that have no TEXTDATA at all like the two firsts ones. Not only I do not know what these transactiosn are, but they are very heavy, they cost alot! What are these transactions? What triggers them? Thanking you in advance. theJazzyBrain

Excellence is not an act, but a habit!

Aristotle