Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #644
| From | Wishmaster <"sysadmin.rock[SINESTO]"@gmail.com> |
|---|---|
| Newsgroups | comp.databases.ms-sqlserver |
| Subject | Re: measuring quantity of transactions |
| Date | 2011-09-06 19:16 -0300 |
| Organization | Newsgroup.cl News Server |
| Message-ID | <j465qb$2v3$1@news.newsgroup.cl> (permalink) |
| References | <j45jek$k0h$1@news.newsgroup.cl> <Xns9F58D651CBA1DYazorman@127.0.0.1> |
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.
Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar
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