Press Release


Technical Article

New Custom Metric: Percentage of blocked connections

This metric reports the number of connections that are currently blocked, divided by the total count of current connections.

Most well-balanced SQL Servers will have some degree of blocking. This metric attempts to measure the impact of lead blocking queries against other queries. Higher values indicate that many connections are being blocked, and queries should be tuned to reduce the amount of contention.

You rated this post out of 5. Change rating

2013-06-07

3,144 reads

External Article

New SQL Monitor Custom Metric: Issues found by sp_Blitz

This custom metric adds Brent Ozar's popular SP_Blitz scripts to Red Gate SQL Monitor. It looks for configuration, security, health and performance problems, and reports back with a list of issues for you to look into. It’s great for quickly understanding the state of a server you've been asked to look after.

2013-05-29

3,470 reads

Blogs

Advice I Like: Experience and Aptitude

By

Experience is overrated. Most breakthrough accomplishments were done by people doing them for the...

Plan Time for Self-Development

By

As you begin the new year, if you don't already have time set aside...

BK’s Bookshelf: Never Split the Difference

By

I picked up Never Split the Difference: Negotiating As If Your Life Depended On...

Read the latest Blogs

Forums

Insiders Selling Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Insiders Selling Data

Join 2 tables

By mtz676

Table A ServerName ColB ServerA C ServerA I ServerA L ServerA M ServerA N...

Impact of Not Including Foreign Keys in an SQL Archive Database

By abdalah.mehdoini

Hello everyone, I am about to start a data archiving project that will affect...

Visit the forum

Question of the Day

Quiesce

What does it mean to quiesce a system?

See possible answers