| Author |
Topic |
|
Gyto
Posting Yak Master
144 Posts |
 Posted - 2009-11-02 : 10:59:30
|
| Hi there,I am trying to use SQL Profiler to capture the number of reads each T-SQL batch is performing, but at the moment it is showing as 0 for everything.I have included the following events:SQL:BatchCompletedRPC:CompletedIs there any other events I should be including in order to get the number of reads to show for each batch or are there some settings I need to check?Thanks,Matt |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-11-02 : 11:02:06
|
SQL:StatementCompleted
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
Gyto
Posting Yak Master
144 Posts |
Posted - 2009-11-02 : 11:10:15
|
| Still no luck unfortunately....it just doesn't seem to be picking them up.Thanks |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-11-02 : 13:56:14
|
Which is the appication you are trying to monitor?
N 56°04'39.26"E 12°55'05.63" |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Gyto
Posting Yak Master
144 Posts |
Posted - 2009-11-04 : 05:53:59
|
| I am just trying to analyze the queries for the database that holds all our timesheet information, however it's not showing the reads for any of the databases.Tkizer, I thought 'reads' was literally the number of logical reads the statement made, rather than the time it took? I will give it a go though....thanks! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Gyto
Posting Yak Master
144 Posts |
Posted - 2009-11-05 : 06:18:18
|
| Is duration an equally good (or better?) indication of query performance? If so I'll just use that... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
SQL Profiler not displaying 'reads'