Performance on a scale from 1 to 10

Question

Performance on a scale from 1 to 10

John Langston

SSCommitted

Points: 1976
More actions
March 10, 2009 at 10:41 am

#218975

I have been asked to create an indicator that would be a blend of SQL Counters which would reflect SQL Server load or stress at given interval (hourly). This indicator would run from 1 (least load) to 10 (highest load). The requestor would be able to look at that number as a general load measure throughout the day
Anyone else ever encounter such a request?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

Set up a range on the various measures. For example, work out what the lightest IO load is (probably 0), and the highest acceptable IO load (will depend on your system). Do the same for CPU, etc. Query the numbers, average the result, you'll have your number.

Given all that, I'm not really sure such a single-score performance monitor is actually worth the effort. Might be, not sure.

- 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

John Langston SSCommitted Points: 1976 More actions · Answer 2

I'm not certain how meaningful it is either, but sometimes you can tell 'em but you can't tell 'em much.

GSquared SSC Guru Points: 260824 More actions · Answer 3

I know how it goes. Good luck on it.

- 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

Grant Fritchey SSC Guru Points: 398707 More actions · Answer 4

I'm not sure how you could do it either, but when you get it done, write it up as an article 'cause I'd love to read it.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Richard Fryar Hall of Fame Points: 3457 More actions · Answer 5

Something that queries and records some wait stats (from sys.dm_os_wait_stats) and a couple of counters from master.dbo.sysperfinfo (e.g. page life expectancy) and reports on the hourly differences.

To get a single number you would have to average a few numbers and scale it into the 1 - 10 range.

As has been said I'm not sure how useful this would be, but it sounds interesting nevertheless.

Check Your SQL Servers Quickly and Easily
www.sqlcopilot.com