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

Re: measuring quantity of transactions

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail
From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: measuring quantity of transactions
Date	Wed, 07 Sep 2011 09:29:54 +0200
Organization	Erland Sommarskog
Lines	30
Message-ID	<Xns9F59609F8ED31Yazorman@127.0.0.1> (permalink)
References	<j45jek$k0h$1@news.newsgroup.cl> <Xns9F58D651CBA1DYazorman@127.0.0.1> <j465qb$2v3$1@news.newsgroup.cl>
Mime-Version	1.0
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	8bit
Injection-Info	mx04.eternal-september.org; posting-host="5slhep4ZgM2dUe3EsTsNxQ"; logging-data="24924"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18QHeCwmy9XEvOPBVdQuo27"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:PDs9Je9fKEZZl0YBWcPPuROgX9g=
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:646

Show key headers only | View raw

Wishmaster ("sysadmin.rock[SINESTO]"@gmail.com) writes:
> PF: Page File Usage

Preferrably, SQL Server should not use the page file at all. OK, so that
is probably a metric you see in Task Manager, but it's an odd way of 
expressing it.

> 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.

Is that 64-bit or 32-bit SQL Server? The number of 2GB makes me think that
you have 32-bit SQL Server, and in that case you have some memory you are
not using (unless there are other applications running on the server as
well.) I would recommend that you enable /PAE in BOOT.INI and enable 
AWE and set max server memory to 4GB.

I would also recommend that you install Service Pack 4 of SQL Server.

-- 
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