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="">

to

<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 http://www.microsoft.com/downloads/details.aspx?familyid=7EDFA95A-A32F-440F-A3A8-5160C8DBE926&displaylang=en and install it. this should over-write the registry key to use the latest.
3) If you had installed http://www.microsoft.com/downloads/details.aspx?familyid=7EDFA95A-A32F-440F-A3A8-5160C8DBE926&displaylang=en, 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:

WordPress.com Logo

You are commenting using your WordPress.com 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