April 13, 2012 at 2:53 am
Need help from the experts on this, I have one test server where 8 instances of SQL server 2005/2008 are running. On four of them SQL performance counters are missiing. i tried to load/unload counters and replaced the sqlctr dll with the working ones but didnt work. Please share if any ideas.
April 13, 2012 at 2:57 am
when you refer to perf counter being missing, where did you look for them?
Perfmon?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 13, 2012 at 3:03 am
Right..performance monitor shows sql counters from other instances but not from four, i find it installation issue but not know what components i need to reinstall..
April 13, 2012 at 3:24 am
The counters are visible on database level but not on OS level(dm_os_performance_counters), i tried to follow one post earlier to make it work but couldnt find any positive results:
http://blogs.msdn.com/b/john_daskalakis/archive/2009/05/07/9593110.aspx
April 16, 2012 at 1:18 pm
Did you add them to it? They are not there by default. You have to add those counters to your monitor.
Jared
CE - Microsoft
April 17, 2012 at 7:59 am
I can find the records in the dmv but they are not visible on performance monitor. I tried to load them by lodctr sqlctr.dll but didn't work.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply