Simon's SQL

SQL,DBA,tuning,Trouble Shooting,Performance

SQL Nexus for SQL 2008 R2 x64

Posted by Simon Cho on 04/12/2011

1. There are no PerfStats for SQL 2008 R2.

for that you need to modified XML file.

<Instance name="*" windowsauth="true" ssver="10" user="">


<Instance name="*" windowsauth="true" ssver="10.5" user="">

SQL Server 2008R2 =10.5

SQL Server 2008 =10

SQL Server 2005 =9

2. x64 issue for RML

Try these steps:
1) go to add/remove programs and uninstall old RML program
2) then download latest and install it. this should over-write the registry key to use the latest.
3) If you had installed, go to C:\Program Files\Microsoft Corporation\RMLUtils and do orca.exe /R from there.
note that this assumes you are using 32 bit. if you are on x64, you need to download 64 bit readtrace

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s