Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Profiler TextData column is NULL

Status
Not open for further replies.
Mar 29, 2004
120
US
Running a trace in Profiler, I see the longest duration corresponds to TextData column = NULL. I'm talking like 10 min duration.

At first I suspected those are system spids, but there's an application name in LoginName column. Then those that have actual statements in TextData have normal duration (several mlsec)

Any ideas?

Thanks
 
It seems to me that you are not using the correct TEXT, nTEXT, Images functions on your querys

AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top