Good URL compressor

is.gd - http://is.gd/8DuwB

Impossible to log SQL 2008 performance counters under Windows 2008 64 bit?

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…

Many, many pretties... piled high beyond the sky

Yes, it could be a lot more small rectangles in it, I know ;o)
(But you can't look too far - when you look too far - it looks back).

Technorati Tags: Task Manager,Multi-core

Browser’s yin yang

Awesome design – click on it to see the page…

Added online chat to my blog

It’s a nice feature of meebo.com

Got on twitter

Follow me on twitter: https://twitter.com/alex_pinsker

Virtual travel over Trans-Siberian railroad with Google

Incredible - 22 day travel over Trans-Siberian railroad - full recorded by Google.
You may listen for "War & Peace" all over during that time :)
http://www.google.ru/intl/ru/landing/transsib/

Technorati Tags: Google,Trans-Siberian