x

Changing MSSQLSERVER service log in account, PF usage in task manager drops

Hello guys,

I'm Czi. I am new here. Please be kind to me. :-) Below is my problem.

I'm trying to setup MS SQL 2000 transactional replication. In our procedure and the procedure i found in the internet, I have to change the log on account of MSSQLSERVER and SQLSERVERAGENT service. I was able to change the log on account but after restart the service, I check the task manager and in the performance tab, i found out that the PF Usage drops from 61GB to 700MB. Is it normal or is there something missing in my configuration?

Note: The account I used is an administrator.

Thank you.

Regards,

Czi

more ▼

asked May 14, 2015 at 10:36 AM in Default

avatar image

iAmCzi
1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Assuming that you are referring to the Page File Usage History from within task manager, this would be expected. You restarted the service which would flush out everything in memory that SQL Server was using. I'm also assuming that you just restarted the SQL instance and not the entire server itself.

I would suspect that you'll start to see the usage climb as more pages are brought into memory for SQL Server to use.

Hope that helps!

more ▼

answered May 22, 2015 at 05:36 PM

avatar image

JohnM
14.2k 3 7 14

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x45

asked: May 14, 2015 at 10:36 AM

Seen: 49 times

Last Updated: May 22, 2015 at 05:36 PM

Copyright 2017 Redgate Software. Privacy Policy