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

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-07 09:29 +0200
Organization	Erland Sommarskog
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>

Show all headers | 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