I wanted to do some performance monitoring on one of our blade servers here at the bank., but ran into a little stumbling block. When trying to create a pretty standard counter log, via performance manger, I noticed that the SQL Server object does not exist for available counters. Pretty strange.
High level SQL Server specs:
Microsoft SQL Server 2005 - 9.00.4053.00 (X64) (Service Pack 3) Standard Edition (64-bit) on Windows NT 5.2 (Windows Server 2003) (Build 3790: Service Pack 2)
I've referenced this MSDN blog post as an FYI of a known issue I suppose. Please let me know your thoughts. I'd really like to track this stuff and setup a performance baseline, but that's going to be pretty challenging if I cannot even count things like:
SQLServer:BufferManager - Buffer cache hit ratio
SQLServer:BufferManager - Page life expectancy
SQLServer:GeneralStatistics - User Connections
SQLServer:MemoryManager - Memory Grants Pending