Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

send fraction metrics as floats + cleaning #1616

Merged
merged 1 commit into from
May 14, 2015

Conversation

yannmh
Copy link
Member

@yannmh yannmh commented May 13, 2015

SQL fractional values represent ratios: it should be casted as float (rather than int) otherwise information is lost behind a rounded 0 int.

Default metrics impacted:

  • Buffer cache hit ratio aka sqlserver.buffer.cache_hit_ratio

More information:
http://blogs.msdn.com/b/psssql/archive/2013/09/23/interpreting-the-counter-values-from-sys-dm-os-performance-counters.aspx

cc @simnyc

@yannmh yannmh added the bugfix label May 13, 2015
@yannmh yannmh self-assigned this May 13, 2015
@yannmh yannmh added this to the 5.4.0 milestone May 13, 2015
@yannmh yannmh changed the title send fraction metrics as gauges + cleaning send fraction metrics as floats + cleaning May 13, 2015
@yannmh yannmh force-pushed the yann/fix-sql-server-wrong-zeros branch from 20a23c4 to d1a6202 Compare May 13, 2015 16:39
@remh
Copy link

remh commented May 14, 2015

lgtm

remh pushed a commit that referenced this pull request May 14, 2015
send fraction metrics as floats + cleaning
@remh remh merged commit 837d926 into master May 14, 2015
@yannmh yannmh deleted the yann/fix-sql-server-wrong-zeros branch May 19, 2015 21:53
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

Successfully merging this pull request may close these issues.

2 participants