Book a Demo

Author Topic: DBMS transaction Rate, Average transaction size  (Read 4157 times)

yiki

  • EA User
  • **
  • Posts: 39
  • Karma: +0/-0
    • View Profile
DBMS transaction Rate, Average transaction size
« on: February 16, 2012, 05:28:21 am »
Our IT is setting up an SQL server DB , he asked me couple questions, that I'm hoping that I could find an answer here.

What is the transaction rate? and the average of transaction size?

and how much total space do we need?

For now our model is small but eventually will be big, since we're gona use the same model for different releases.

thanks

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: DBMS transaction Rate, Average transaction siz
« Reply #1 on: February 16, 2012, 05:45:16 pm »
We have a pretty large model containing about 70.000 elements which currently takes up about a gigabyte of space on SQL Server

I'm not sure how EA deals with transactions, but it launches 100's of queries a second at the database.
I suspect each individual query is a small transaction.

Geert

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: DBMS transaction Rate, Average transaction siz
« Reply #2 on: February 16, 2012, 08:28:52 pm »
Your model will eventually start growing after turning on auditing. But in terms of databases this is only peanuts.

q.

yiki

  • EA User
  • **
  • Posts: 39
  • Karma: +0/-0
    • View Profile
Re: DBMS transaction Rate, Average transaction siz
« Reply #3 on: February 29, 2012, 04:21:04 am »
I got an estimate from the IT guys of  transaction size of 10K bytes, averaging about 600 transaction per hour.  
Do you guys think that is good enough?