Bringing It All Together with SQL Nexus - SQL Server 2012 Internals and Troubleshooting - page 346

RESOLVING COMMON ISSUES

This section describes the most common issues that users of RML Utilities and SQL Nexus face,
including the best way to resolve them.

Issue #1
While trying to import a SQL Trace i le using SQL Nexus, you might get the following error in the
SQL Nexus log i le:

"The system cannot find the file specified (System)"
Program Location:
at System.Diagnostics.Process.StartWithCreateProcess(ProcessStartInfo startInfo)
at System.Diagnostics.Process.Start()
at System.Diagnostics.Process.Start(ProcessStartInfo startInfo)
at ReadTrace.ReadTraceNexusImporter.DoImport() in
C:\jacklidocs3\cprsrc\main\src\sqlnexus_pass\ReadTraceNexusImporter\
ReadTraceNexusImporter.cs:line 364
at sqlnexus.fmImport.DoImport() in
C:\jacklidocs3\cprsrc\main\src\sqlnexus_pass\sqlnexus\fmImport.cs:line 557

This message could appear for either of the following reasons:

➤

Your RML Utilities version is older than the current version. If so, install the latest version
of RML Utilities.

➤

Your RML Utilities location is not registered with SQL Nexus. To correct this, navigate to
C:\Program Files\Microsoft Corporation\RMLUtils and from the command prompt
execute orca.exe /R .

Issue #2
When you run Reporter with the default settings, you get the following error:

Server: (local) Error: 4060 Severity: 11 State: 1 Line: 65536 Source: .Net
SqlClient Data Provider
Cannot open database "PerfAnalysis" requested by the login. The login failed.

When you launch Reporter, which is part of the RML Utilities installation, the PerfAnalysis
database is the default database to which it will attempt to connect. You need to change the name of
the baseline database to the database into which you imported the SQL Trace i les using SQL Nexus
in order to generate reports and avoid the preceding error message.

Issue #3
If you are unable to view the Blocking and Wait Statistics report or the Bottleneck Analysis report,
or you receive the error “Database doesn't have the necessary data to run this report,” then the
required data is not present in the SQL Nexus database tables required to render the report. This
seems obvious enough from the error message, but you need to determine whether sufi cient data is