March 24, 2015 at 3:53 am
Hi All,
SQL Server 2014 BI
Windows 2008 R2
Every time machine is rebooted performance counters are missing.
select * from sys.dm_os_performance_counters returns no records. I execute "lodctr" command and get it back every time.
I would like to know the route cause of this issue, why it gets removed every time the machine is rebooted.
We suspect its causing some other issues as well. Will windows team be able to check on this ?
Can someone please guide, Thanks !.
San.
March 24, 2015 at 4:24 am
This is by design. DMV data is dropped when SQL Server is restarted. If you want to keep them you need to do some data collection into permanent tables either locally or on a central management server.
What other issues do you think are linked ?
The SQL engine does not use the data in these DMV's for anything so the lack of data in the DMV's is not likely to cause other issues. When SQL Server is restarted the plan cache is cleared so on restart you may see new plans being generated. The plan that is generated is often optimized for the @parameters passed the first time the procedure is called so this can lead to unexpected plans in cache that may not be optimal for other workloads.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply