February 29, 2012 at 1:55 pm
Hi Everyone,
Hope all is well.
I am noticing an issue with my perfmon on the sql prod server. I am seeing zeros for the following counters ever since the SQLserver services were restarted. The reason for the service restart was due to the change in SQL Server service account to run as a domain service account instead of local system:
Batch Requests/sec
SQL Re-Compilations/sec
SQL Compilations/sec
Memory Grants Pending
Transactions
User Connections
Page reads/sec
Buffer cache hit ratio
Free list stalls/sec
Checkpoint pages/sec
Lazy writes/sec
Page life expectancy
Page writes/sec
Is there a way that I can fix this issue?
Thanks in advance
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
February 29, 2012 at 2:17 pm
I am using SQL Server 2008 R2 X64 SE on Windows Server 2008 R2 EE.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
February 29, 2012 at 2:34 pm
try this command
lodctr /r
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 29, 2012 at 3:51 pm
Thanks for the reply SQLRNNR..but would this require any service or server reboot? or would it affect any apps connected to the sql server right now if i execute the command from the prompt?
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
February 29, 2012 at 4:23 pm
that command is for perfmon to refresh the perf counters.
There should be no negative impact
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 29, 2012 at 7:28 pm
SQLRNNR I have just run the command as an administrator but I still see the zeroes for all the above perfmon counters. But I dont see any issues as of now from the database or from the application.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
February 29, 2012 at 8:23 pm
Are you able to see the same details using select * from sys.dm_os_performance_counters?
Regards,
Raj
February 29, 2012 at 9:26 pm
That query returns me zero records...I wonder the zeros got anything to do with the permissions of new SQLServer Service account that has been put in place of local system..please advice.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
February 29, 2012 at 10:01 pm
I think I figured out the issue..I had the perfmon running while the service account was being changed...I will restart the sql server service and check if that fixes the issue..
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply