From: "sysadmin.rock[SINESTO]"@gmail.com   
      
   On 06-09-2011 16:04, Erland Sommarskog wrote:   
   > 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?   
   >   
   >   
   PF: Page File Usage   
      
   Server specs: IBM X3650   
   -Intel Xeon X5450 3 Ghz   
   -6 GB RAM   
   -MS Windows Server 2003 R2 (Enterprise.Ed) SP 2   
   -SQL Server 2005 Enterprise Ed.   
      
   Awe is not enabled.   
      
   Erland   
   Thanks for your answer.   
      
   Diego.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)