Here is some strange problem I’ve experienced (right now it seems to me as a bug in Windows 2008 64 bit):
I have an environment with Windows 2008 64 bit and SQL Enterprise 64 bit.
To begin with - it's possible to see SQL-related performance counters values only in perfmon opened from SysWow64 (i.e. 32 bit) - they are not present in 64-bit perfmon.
Now, if I open perfmon (32 bit) and add any SQL counters (e.g. SQL Latches) to the "Performance Monitor" section I can see that those values are updated "live" in perfmon graphs.
Yet, if I create a new Data Collector Set for the same values under Data Collector Sets -> User Defined - the values for SQL counters are not being stored in the created log file. If I add some other counters (e.g. Processor) they ARE saved.
Seems that this is some sort of bug/problem related to 64 bit…
There are some clues on this problem in two following articles:
- http://www.code-magazine.com/Article.aspx?quickid=080015
- http://blogs.msdn.com/psssql/archive/2009/03/03/troubleshooting-sql-server-2005-2008-performance-counter-collection-problems.aspx
but both do not help (for the first one – there is no such service anymore in Windows 2008…
1 comment:
Solution found:
http://alexpinsker.blogspot.com/2010/03/solution-for-impossible-to-log-sql-2008.html
Post a Comment