Batch Request per sec

Question

Batch Request per sec

tony28

SSCertifiable

Points: 7112
More actions
March 26, 2014 at 7:31 pm

#396485

Hello,
I check our batch request per sec and we have about 2,5-3k for one sec...
what number do you have on your server ?

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

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

free_mascot One Orange Chip Points: 27169 More actions · Answer 1

What is transactions/sec on your server/database?

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

tony28 SSCertifiable Points: 7112 More actions · Answer 2

free_mascot (3/26/2014)
What is transactions/sec on your server/database?

I used this and about 750-850

DECLARE @cntr_value bigint

SELECT @cntr_value = cntr_value

FROM sys.dm_os_performance_counters

WHERE counter_name LIKE 'Transactions/sec%'

AND instance_name LIKE '_Total%'

WAITFOR DELAY '00:00:01'

SELECT cntr_value - @cntr_value

FROM sys.dm_os_performance_counters

WHERE counter_name LIKE 'Transactions/sec%'

AND instance_name LIKE '_Total%'

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

I've seen 10, I've seen 50000. You can't compare that number to someone else, it's about your specific workload.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

tony28 SSCertifiable Points: 7112 More actions · Answer 4

GilaMonster (3/27/2014)
I've seen 10, I've seen 50000. You can't compare that number to someone else, it's about your specific workload.

Yes, I was thinking about it. Is any way how to find that our server is ok with these numbers?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Compare to previous baselines.

Also, if the server isn't handling that number, you can't exactly go to the users and tell them to do less work. Rather you'd have to tune/upgrade as necessary to ensure that SQL can handle all the batch requests coming to it.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass