Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

OLTP process question Expand / Collapse
Author
Message
Posted Thursday, August 14, 2014 9:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 4, 2014 1:18 AM
Points: 1, Visits: 18
If our processes run every 2 minutes on 3 DBs simultaneously, everything is fine... why are we encountering problems if we run our processes every 2 minutes on more than 3 DBs? Assumption: We have more or less 20,000 SQL statements to execute for each DB every 2 minutes?
Our goal is to finish the process within 2 minutes for 40 DBs and more.

Any recommendations to improve performance or what to check that cause it to slow down when we increase the # of database to process? Will using SAN disk be of help?

- SQL Server 2008 R2
- data and log files are currently located in drive C:
- bytes per cluster on drive C:is set to 4kb.
Post #1603556
Posted Thursday, August 14, 2014 9:18 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:40 PM
Points: 2,533, Visits: 7,098
sandie_zarate (8/14/2014)
If our processes run every 2 minutes on 3 DBs simultaneously, everything is fine... why are we encountering problems if we run our processes every 2 minutes on more than 3 DBs? Assumption: We have more or less 20,000 SQL statements to execute for each DB every 2 minutes?
Our goal is to finish the process within 2 minutes for 40 DBs and more.

Any recommendations to improve performance or what to check that cause it to slow down when we increase the # of database to process? Will using SAN disk be of help?

- SQL Server 2008 R2
- data and log files are currently located in drive C:
- bytes per cluster on drive C:is set to 4kb.


First priority would be separating the data from the OS activity, given the C: is the OS / page file drive. After that one can start gathering statistics and ironing out other bottlenecks, the average of 170 statements per second doesn't sound much but it mounts up, 40 dbs and its approaching 7000 per second.
Post #1603557
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse