Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Look at the size of my BCHR


Look at the size of my BCHR

Author
Message
Tony Davis
Tony Davis
Say Hey Kid
Say Hey Kid (661 reputation)Say Hey Kid (661 reputation)Say Hey Kid (661 reputation)Say Hey Kid (661 reputation)Say Hey Kid (661 reputation)Say Hey Kid (661 reputation)Say Hey Kid (661 reputation)Say Hey Kid (661 reputation)

Group: Administrators
Points: 661 Visits: 1153
Comments posted to this topic are about the item Look at the size of my BCHR
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)

Group: General Forum Members
Points: 54629 Visits: 40391
BWAA-HAAA!!! "I'll show you mine if you show me yours."

I've never looked, but I'm just betting that the BCHR is nearly 100% for cursors... Wink

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Michael Valentine Jones
Michael Valentine Jones
Hall of Fame
Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)

Group: General Forum Members
Points: 3948 Visits: 11771
I have rarely seen anything below 99%, so I don’t pay much attention to it.

I look more at Average Page Life Expectancy and Page Reads/Sec. These seem to be more volatile and let you know how much thrashing of data pages in and out of memory the server is doing and how much of a bottleneck getting data from disk is.
Steve Jones
Steve Jones
SSC-Forever
SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)

Group: Administrators
Points: 42018 Visits: 18876
I've honestly stopped checking this at many servers since they're usually > 90%. However I have seen it in the 80s or lower and more memory almost always solves this and gives a little boost.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
george sibbald
george sibbald
SSCertifiable
SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)

Group: General Forum Members
Points: 7278 Visits: 13687
well its one of the default performance counters in MOM, which raises a critical alert if it goes below 90% for more than 15 mins (by default) so I guess MS still consider it an indicator of performance.

For myself i admit its nice to see it up high and its something I track as part of memory monitoring but I would only really worry about it if it was ALWAYS low.

---------------------------------------------------------------------
Elisabeth Rédei
Elisabeth Rédei
SSC Veteran
SSC Veteran (225 reputation)SSC Veteran (225 reputation)SSC Veteran (225 reputation)SSC Veteran (225 reputation)SSC Veteran (225 reputation)SSC Veteran (225 reputation)SSC Veteran (225 reputation)SSC Veteran (225 reputation)

Group: General Forum Members
Points: 225 Visits: 788
Hi,

Since not all memory requests will reflect in the counter you could have > 90% and still have memory issues (and with issues I don't mean low on memory; over consumption is more often the case Tongue).

But as Steve pointed out, if you encounter a low BCHR and add some memory, there will usually be a performance boost whereas a high number doesn't necessearily mean all is well.

There could be memory issues elsewhere in the bufferpool - anything that goes through the Memory Broker for instance (large memory requests, queries with sort/hash operators, memory for parallel plans etc.) or in the memory area formerly known as mem_to_leave.

I tend to ignore it completely when it's high.


/Elisabeth

elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei
katedgrt
katedgrt
SSC Veteran
SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)

Group: General Forum Members
Points: 227 Visits: 990
By itself it is not a key indicator, but it can be an important clue if you are having performance issues.

Cool Kate The Great w00t
If you don't have time to do it right the first time, where will you find time to do it again?
IceDread
IceDread
Old Hand
Old Hand (363 reputation)Old Hand (363 reputation)Old Hand (363 reputation)Old Hand (363 reputation)Old Hand (363 reputation)Old Hand (363 reputation)Old Hand (363 reputation)Old Hand (363 reputation)

Group: General Forum Members
Points: 363 Visits: 1145
I dont use it. I measure the time/ workload it takes to perform different tasks that is prio.
GSquared
GSquared
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16625 Visits: 9729
I've never bothered with it. Maybe I should, but I never have.

I've found tracking runtime on queries to be much more useful to me in performance tuning.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Steve Jones
Steve Jones
SSC-Forever
SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)

Group: Administrators
Points: 42018 Visits: 18876
Interesting you've never used it. I use this as a first glance when I get a complaint about a new server. It's a thumb-sketch to see if this is grossly out of whack.

Once I'm familiar with a server, I'd probably never look at it again.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search