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.
asked May 14, 2015 at 10:36 AM in Default
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!
answered May 22, 2015 at 05:36 PM