question

ShakyKnees avatar image
ShakyKnees asked

Profiler "Replay Statistics Event"

Output from my SQL2008R2 Profiler Replay ends with an event of EventClass: "Replay Statistcs Event", with Textdata such as: Replay server: TESTSQLS02\MIG Total events = 180036 Replayed events = 2026 Provider errors = 0 Internal errors = 15 Total errors = 15 Provider hit ratio = 100.00 % Internal hit ratio = 99.26 % Overall hit ratio = 99.26 % Replay time = 0 hr 16 min 50 sec 903 ms I have been unable to locate credible definitions of the hit-ratio stats. I doubt the statement I saw in a forum, that they represent "the cache hit ratio", which is an imprecise term at best.
sql-server-2008-r2profilerreplay
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ShakyKnees avatar image
ShakyKnees answered
THANKS! Three follow-on questions: 1. Please contrast "Total events" vs. "Replayed events". I have some guesses, but I'd like your version better. 2. Please contrast "Provider" vs "Internal" event subclasses listed. 3. (teach a man to fish): How would I have located this information, i.e. did you have to use the secret MVP handshake, or did I simply fail to properly word my queries on MSFT site? Er whut? BTW, thanks for SQL In the City (Seattle). 'Twas great!
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Total events are all the events in the stack and replayed events are the ones that could be replayed. Some events are informational, so they won't be "replayed". Internal vs. Provider... I'm not sure. Secret handshake? Nah. Just lots of mistakes piled up over years. And a little google-fu: http://msdn.microsoft.com/en-us/library/ff878467.aspx And you're welcome. Thanks for attending.
0 Likes 0 ·
Oh, and if the answer was helpful, be sure to click the thumbs up. If it was the answer to the question click the checkmark.
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
It represents how many of the queries during the replay were able to successfully complete. The number of events you replayed was 2026. The number of errors you had was 15. The ratio there is 99.26%. And yeah, it's not the cache hit ratio. That's nuts.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ShakyKnees avatar image
ShakyKnees answered
Thanks for the link. I gotta stop filtering my MSFT searches to SQL2008R2 when I come up empty. BTW, the canned "TSQL_Replay" template (in 2008 R2 at least) is missing the TextData column for Stored ProcRPC events, which made them unplayable (the "could be replayed" category you mentioned), eliminating 98% of my traffic. I've saved my own edited version of that template with TextData added for Stored Procedures: "RPC:Starting" and "RPC:Completed", and it made traces usable.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.