From: esquel@sommarskog.se   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)