Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
larsonhokie
Starting Member
3 Posts |
 Posted - 2012-03-28 : 18:14:17
|
| I am assisting a group in troubleshooting a problem where I would like to collect perfmon data from SQL Server 2005. In the following article, http://support.microsoft.com/kb/891238, I saw that I needed to use mmc.exe /32 perfmon.msc to access the counters. The article called Some performance counter objects are not available for a 32-bit process on 64-bit versions of Windows Server 2003 leads me to believe that if I can see the counters, I should be able to save them. When I create a User Defined - Data Collector set to monitor SQL counters, I can see them, add them. But, when I go to see the data, none of them are present. If I have the collector set have other system based items (like CPU utilization), then they will be saved and collected, but the sql ones always disappear from the report. If I create one with only sql counters, then an error will come up in the report saying that I do not not have the minimum of 2 data points to see a result set.Our ultimate goal would be to use this data set with profiler to see what is happening when we have events occur in perfmon. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-03-28 : 18:50:13
|
| Why not just run perfmon from a 32 bit host instead?what specific counters are unavailable that you're after? |
 |
|
|
larsonhokie
Starting Member
3 Posts |
Posted - 2012-03-29 : 14:45:30
|
| Thank you for the reply. We can plot the counters with the perfmon.msc /32 option, but since we cannot save the data to a file, we cannot load them in with profiler to correlate the results. I believe the easiest thing for the group to do is to perform an upgrade of the SQL Server System to a 64 bit version of SQL Server 2008. Fortunately we have that option. I am surprised that nobody else has had this issue (a little surprised).Regards,LH |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-03-29 : 15:28:45
|
| I don't disagree about upgrading from 32 to 64 bit in general, but easier than running perfmon from a 32 bit box? No.You don't have a single 32 bit machine (XP, Win 2003) that you can run the trace from? |
|
|
|
larsonhokie
Starting Member
3 Posts |
Posted - 2012-03-29 : 16:01:07
|
quote:
Originally posted by russell
Why not just run perfmon from a 32 bit host instead?what specific counters are unavailable that you're after?
FYI - we did try it just to see what would happen, and the SQL counters did not show up with another 32 bit OS (windows 2003). I saw a few database related counters, but not the ones we needed. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-03-29 : 17:05:22
|
| Which ones? |
|
|
|
|
|
|
|
|
Unable to save sql server 32 bit counters with per