Groups > comp.databases.ms-sqlserver > #642

Re: measuring quantity of transactions

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: measuring quantity of transactions
Date	2011-09-06 21:04 +0200
Organization	Erland Sommarskog
Message-ID	<Xns9F58D651CBA1DYazorman@127.0.0.1> (permalink)
References	<j45jek$k0h$1@news.newsgroup.cl>

Show all headers | View raw

Wishmaster ("sysadmin.rock[SINESTO]"@gmail.com) writes:
> How can I measure the hardware capacity of  my server to handle 
> transactions?
> This is the situation.
> A customer ask us if we can handle the incoming grow of transactions of 
> their systems(about 25% more than the current quantity of transactions)
> The database server never shows more than an average use of 10% CPU and 
> uses 2 GB of PF with 6 GB of RAM. I know for sure that our server is 
> handling quite good the current charge and there is no problem to accept 
> a 25% more but, How can I explain this to my client? The client 
> understood as successful transaction entering a row to their DB.
> How can I determine how many transactions can my server handle.

Such questions are not trivial to answer with certainty, because there
may be points where something gets saturated, and the performance
decreases drastically. From what I say, I would not expect that to happen
only because of a 25% increase.

Is 6 GB the entire amount of memory for the server? That is very timid
these days.

What do you mean with PF?

Do you have 32-bit or 64-bit SQL Server? In the former case is AWE and
PAE enabled?

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

measuring quantity of transactions Wishmaster <"sysadmin.rock[SINESTO]"@gmail.com> - 2011-09-06 14:02 -0300
  Re: measuring quantity of transactions Erland Sommarskog <esquel@sommarskog.se> - 2011-09-06 21:04 +0200
    Re: measuring quantity of transactions Henk van den Berg <me@myplace.net> - 2011-09-06 22:13 +0200
    Re: measuring quantity of transactions Wishmaster <"sysadmin.rock[SINESTO]"@gmail.com> - 2011-09-06 19:16 -0300
      Re: measuring quantity of transactions Erland Sommarskog <esquel@sommarskog.se> - 2011-09-07 09:29 +0200
        Re: measuring quantity of transactions Wishmaster <"sysadmin.rock[SINESTO]"@gmail.com> - 2011-09-07 10:59 -0300

csiph-web