sql server - Select returns no rows - queries in trace file -

-

i imported trace file using 

select * trace_table ::fn_trace_gettable('c:\my_trace.trc', default)

while analyzing imported trace file noticed select statements take significant amount of time (duration) , cpu @ end not return rows (rowscount == null). 

select textdata, clientprocessid, eventclass         , duration, starttime, endtime         , reads, writes, cpu, rowcounts         , eventsequence,  textdata_md5_hash             , applicationname, spid myimportedtrace        textdata_md5_hash in (0x4a943f266010bdd2a47179dc3481bc7f) order spid, starttime, eventsequence

example

slow select without rows

test in query window

if copy same query textdata-field query window lot of rows (>200000)

questions

  • what might reason query did not return rows?
  • was query terminated ?
  • how recognize failed query executions in trace file?

update / edit after answer accepted

this query

use mydatabase select ti.eventclass, te.eventname, count(*) countasterisk     , sum(ti.rowcounts) rowcountssum     , sum(ti.duration/1000) durationsum_ms     , avg(ti.duration/1000) durationavg_ms traceimport ti     left join traceevents te            on ti.eventclass = te.eventtraceid group ti.eventclass, te.eventname  order eventclass

returns result

group trace rows event class

sys.fn_trace_gettable returns every possible column might have been captured.

there no guarantee actual trace looking @ did capture rowcounts every relevant event class.

based on information have provided far there no reason think trace wasn't set this.

inside click on tools / sql server profiler opens application in window trace properties click on tab event selection , make sure column rowcounts checked event class sql:batchcompleted

sql server profiler / trace properties / event selection


Comments

Post a Comment

Popular posts from this blog

c - zlib and gdi32 with OpenSSL? -

-
this follow question undefined reference rsa_generate_key in openssl? have openssl program generate rsa key, follows : #include <stdio.h> #include <openssl/rsa.h> #include <openssl/pem.h> int main(int argc, char* argv[]) { rsa *r = null; int ret; r = rsa_new(); bignum *bne = null; ret = rsa_generate_key_ex(r, 2048, bne, null); return 0; } when compile gcc -i../include rsatest.c -lcrypto -l. i undefined reference errors functions in libraries gdi32 , zlib. so correct this, have add -lz , -lgdi32, as gcc -i../include/ rsatest.c -lcrypto -lz -lgdi32 -l. my question is, aren't static libcrypto , libssl self sufficient? in why having add libraries make work? there option should have added while compiling library prevent this? i'm using 64 bit windows mingw compiler. made openssl library of msys , make.
Read more

java - inputmismatch exception -

-
Image
this question has answer here: scanner skipping nextline() after using next(), nextint() or other nextfoo()? 14 answers import java.util.*; public class ngg { static scanner numberentered; static scanner userinput = new scanner(system.in); static int guessednumber; static int randomnumber = (int) (math.random()* 11); static scanner reply; static string answer; public static void main(string[] args) { guesschecker(guessednumber); } public static void guesschecker(int userguess) { while (userguess != randomnumber) { intro(); userguess = intchecker(); if (userguess == randomnumber) { system.out.println("congradulations!"); system.exit(0); } else { system.out.println("that incorrect!");...
Read more

ios - Align baselines with characters in large line heights with Text Kit -

-
Image
when draw attributed string fixed line height text kit, characters aligned bottom of line fragment. while make sense on 1 line characters varying in size, breaks flow of text multiple lines. baselines appear decided largest descender each line. i've found article people behind sketch explaining exact problem in bit more detail , showing solution does, not explaining how achieved this. this want basically: when showing 2 lines large line height, result far ideal: the code i'm using: let smallfont = uifont.systemfont(ofsize: 15) let bigfont = uifont.systemfont(ofsize: 25) let paragraphstyle = nsmutableparagraphstyle() paragraphstyle.minimumlineheight = 22 paragraphstyle.maximumlineheight = 22 var attributes = [ nsfontattributename: smallfont, nsparagraphstyleattributename: paragraphstyle ] let textstorage = nstextstorage() let textcontainer = nstextcontainer(size: cgsize(width: 250, height: 500)) let layoutmanager = nslayoutmanager() textstorage.append(n...
Read more