Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Batch Request per sec Expand / Collapse
Author
Message
Posted Wednesday, March 26, 2014 7:31 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 3, 2016 12:07 AM
Points: 268, Visits: 889
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 ?




How to post data/code on a forum to get the best help: Option 1 / Option 2
Post #1555240
Posted Wednesday, March 26, 2014 10:49 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 17, 2016 5:13 AM
Points: 2,796, Visits: 2,232
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."
Post #1555255
Posted Wednesday, March 26, 2014 11:03 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 3, 2016 12:07 AM
Points: 268, Visits: 889
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%'





How to post data/code on a forum to get the best help: Option 1 / Option 2
Post #1555260
Posted Thursday, March 27, 2014 12:51 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:59 AM
Points: 45,296, Visits: 43,511
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

Post #1555286
Posted Thursday, March 27, 2014 12:56 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 3, 2016 12:07 AM
Points: 268, Visits: 889
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?




How to post data/code on a forum to get the best help: Option 1 / Option 2
Post #1555289
Posted Thursday, March 27, 2014 2:26 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:59 AM
Points: 45,296, Visits: 43,511
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

Post #1555306
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse