John site says this do this mean i hav to add a memory....

If the Total Server Memory (KB) counter is consistently high compared to the amount of physical memory in...

John

CPU utilization goes upto 85 to 90 % as there are 50 + users accessing the database ....

max memory set to 10 GB

were as i hav some processes which are slowing down as it utilize all the 10GB.

40 GB database size.

john 14 GB ram

john do i required more ram.....

please reply

SQL server version/edition:standard

OS version/edition:windows x64

min memory for sql:not set

max memory for sql:10 GB

what to do if my Page life expectancy > 300

Buffer Manager\Page life expectancy = 1398

1413

1428

1443

1458

1473

1488

1503

1518

1533

1548

1563

1578

1593

1608

1623

1638

1653

1668

1683

1698

1713

1728

target 10485760

total 1901312

Locks(_Total)\Lock Requests/sec

11484.22032

OS windows x64

Awe is enabled

waiting for the reply..........

hi .. wen i check this counter i m geting this value m confused wat to do

\\FICBRMFOTEST02\Process(sqlservr)\% Processor Time

0.833312001

57.29020004

111.1429881

191.5575961

199.7865521

179.9953921

126.3509321

37.91569602

72.39398005

133.9549041

157.7042961

199.9948801

158.9542641

100.8307521

75.83139205

1.562460001

4.791544003

14.99961601

14.68712401

13.12466401

9.791416006

as the total processor time is max it goes...

a

my sqlserver services runs under local account .... so i hav to add that user in lock memory as it ask for this

how do i do this ......'Lock Pages in Memory' permission to the SQL Server service.

waiting for the reply..

Enterpise...Edition,................ Sam