Databases Reference
In-Depth Information
Using PerfMon on 64-bit Systems Using WOW
When running x64 Windows with x86 SQL Server, you're using Windows on Windows (WOW),
which means x64 Windows is emulating an x86 environment to host x86 SQL Server. If you're using
x64 Windows and x64 SQL Server, this section isn't relevant to you.
When PerfMon runs on an x64 host, none of the counters pertaining to x86 applications are avail-
able because the x64 PerfMon cannot load x86 counters. You can overcome this by launching the
x86 version of the Microsoft Management Console (MMC) with the PerfMon snap-in. Run the fol-
lowing to launch the PerfMon x86 from an x64 Windows computer:
mmc /32 perfmon.msc
NOTE
If you're running SQL Server in a Windows on Windows (WOW)
mode — i.e., x86 SQL Server on x64 Windows — you'll be unable to run
PerfMon remotely from other x64 machines because the remote Registry ser-
vice is an x64 process; therefore, counters are visible only to x86 processes.
Remote Monitoring Fails
If you're trying to monitor remote servers without any success, the most likely cause is permissions
problems. Try the following troubleshooting tips:
➤
Ensure that the account is local administrator on the target server.
➤
Coni rm NetBIOS access to the target server.
➤
Ensure that the remote Registry service is running on the target server.
➤
Ensure that no local security policy or Active Directory group policy is restricting access.
SQL Server Counters Are Missing
When you open PerfMon, you might i nd that there are no SQL Server counters available in the
counter list. This problem occurs more often on clustered instances. If counters are missing, check
the SQL Server Error Log and the Windows Event Application log to determine whether any errors
are logged regarding the failed counters. If there are no errors in either log, you can unload the
counters as follows:
unlodctr mssqlserver
Once the counters have been unloaded, verify the path to
sqlctr.ini
and use the following com-
mand to reload the counters:
lodctr C:\Program Files\Microsoft SQL Server\MSSQL10.1\MSSQL\Binn\sqlctr.ini
As with any change, test the process on a nonproduction server to gain coni dence in the process
(even if there is no problem on the test server, you can still test the commands). After reloading the
counters, if they still aren't listed, use the following process to rebuild them.
Search WWH ::
Custom Search