April 7, 2009 at 7:14 am
Set “Lock Pages in Memory”:
Open the Group Policies Console:
START-RUN , enter - gpedit.msc
Computer Configuration - Windows Settings - Security Settings – Local Policies - User Rights Assignment
In the detail, open “Lock Pages In Memory”.
Click – ADD
Add the SQL Server start-up acct.
Tim White
April 7, 2009 at 7:20 am
2 Tim 3:16 (4/7/2009)
Set “Lock Pages in Memory”:Open the Group Policies Console:
START-RUN , enter - gpedit.msc
Computer Configuration - Windows Settings - Security Settings – Local Policies - User Rights Assignment
In the detail, open “Lock Pages In Memory”.
Click – ADD
Add the SQL Server start-up acct.
hi what is a SQL server start up acct???
thanks
April 7, 2009 at 7:23 am
The Service Account of your SQL Server.
Tim White
April 7, 2009 at 7:28 am
2 Tim 3:16 (4/7/2009)
The Service Account of your SQL Server.
how we know that this particular account is the service account.
is it wen i login SSMS it give windows authentication ?? is it tha that one
April 7, 2009 at 7:32 am
go into the SQL Server Configuration Manager. On the left side, click on SQL Server Services. On the right side you will see the account that each service is running under.
After you set the Lock Pages in memory, you will need to cycle SQL. Maybe even reboot, I don't remember about the reboot.
Tim White
April 7, 2009 at 7:46 am
Its Log on as Local system Accountits my own laptop does this mean i logging in as administrator?
April 7, 2009 at 7:49 am
how this works in real production environment sorry i dont have exprience. if say a developer wants to access, then on his desktop he has SSMS? and he connects to the sql server with the user account we provided/?
April 7, 2009 at 10:27 pm
a
April 8, 2009 at 4:32 am
samsql (4/7/2009)
a
b:-D
????
April 8, 2009 at 4:36 am
Click Start, click Run, type gpedit.msc, and then click OK. The Group Policy dialog box appears.
Expand Computer Configuration, and then expand Windows Settings.
Expand Security Settings, and then expand Local Policies.
Click User Rights Assignment, and then double-click Lock pages in memory.
In the Local Security Policy Setting dialog box, click Add User or Group.
In the Select Users or Groups dialog box, add the account that has permission to run the Sqlservr.exe file, and then click OK.
Close the Group Policy dialog box.
Restart the SQL Server service.
April 8, 2009 at 8:31 am
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 to ..... 25 %
and i want some help for this value and wat to do .....
Memory Manager KB
------------------------------ --------------------
VM Reserved 3018640
VM Committed 54372
AWE Allocated 1908736
Reserved Memory 1024
Reserved Memory In Use 0
April 8, 2009 at 10:35 pm
waiting for the reply..........
Viewing 12 posts - 16 through 26 (of 26 total)
You must be logged in to reply to this topic. Login to reply