Top Issues

We are tracking top issues here. Please visit this page before posing https://sqlnexus.codeplex.com/wikipage?title=Top%20Issues

Id #25257 | Release: None | Updated: Mar 11 at 9:59 PM by jackli | Created: Mar 11 at 6:54 PM by jackli

Error in SQL_2008_Perf_Stats_Snapshot_Shutdown.OUT

I try to collect statistcs using PSSDIAG, I have following error in the SQL_2008_Perf_Stats_Snapshot_Shutdown.OUT file   -- top 10 logical reads by query_hash -- Sqlcmd: Error: Microsoft SQL Server...

Id #22278 | Release: None | Updated: Feb 21, 2013 at 11:49 PM by zokrc | Created: Feb 23, 2012 at 4:59 PM by WaldiMen

Error importing BLG on Windows 7 SQL2008

Getting the following error at the stage of importing the BLG. It seems to process it fine but then comes up with the database connection failure:   SQLNexus Information: 0 : BLG Blaster (Perfmon/S...

Id #20177 | Release: None | Updated: Feb 21, 2013 at 11:49 PM by Norberto2021 | Created: Mar 9, 2011 at 11:51 AM by bimaldave

StartSQLDiagTrace command file in 3.0.0.0

Where is StartSQLDiagTrace command file in 3.0.0.0 which is used to start trace and collect data? I could not find it. Any help will be appreciated. Thank you

Id #20013 | Release: None | Updated: Feb 21, 2013 at 11:49 PM by amitban | Created: Feb 14, 2011 at 6:41 PM by usxg049

Timeout error when running the Blocking and Wait Statistics report

I successfully imported all the collected data. I selected a very broad time range from the parameters window and clicked "Ok". After 30 seconds I received this error in the log file:   SQLNexus ...

Id #19940 | Release: None | Updated: Feb 21, 2013 at 11:49 PM by amitban | Created: Feb 7, 2011 at 7:32 PM by gsprague

Query Hash Reports don't work properly

Hi all,   I have a minor problem with the Query Hash Report. I can only view the Top Queries by CPU. If I choose Duration or Logical Reads, then the report fails with a large exception message (see...

Id #19587 | Release: None | Updated: Feb 21, 2013 at 11:49 PM by amitban | Created: Jan 6, 2011 at 8:00 PM by Feleryan

Error reading trace file

Hi All   I am getting the following error when SQLNexus (actually ReadTrace) is reading my trace file. My environment is:   Windows 2008 R2 SQL 2008 R2 SQL 2005 with SP 4 (I thought it would not w...

Id #19393 | Release: None | Updated: Feb 21, 2013 at 11:49 PM by amitban | Created: Dec 21, 2010 at 5:07 PM by tariqrazzaq

Add Extended Events as a Analysis Source

With all of the SQL Trace Events being available in Denali CTP1, Extended Events have become a viable alternative to SQL Trace for tracing a SQL Server with minimal overhead. The asynchronous file...

Id #19314 | Release: SQL Nexus 3.0.0.0 release | Updated: Feb 26, 2013 at 10:28 AM by s_osborne2 | Created: Dec 16, 2010 at 2:07 PM by jmkehayias

Realtime Server Status report does not work when connecting to SQL 2008

Reason: Column cpu_ticks_in_ms of view sys.dm_os_sys_info was replaced with ms_ticks in SQL 2008 and higher. SQL Nexus Version: 3.0.0.0   Hi,   I researched into this since I used this report frequ...

Id #19079 | Release: None | Updated: Jun 14, 2013 at 7:28 AM by amitban | Created: Nov 9, 2010 at 11:32 AM by ecce2k

BLG file import broken in Windows 7

Hi,   It looks like the BLG file import is broken in Windows 7 (and Win 2008 R2). The error message is about a failed connection to SQL Server from the Performance Data Helper (PDH) so I'm guessin...

Id #17449 | Release: None | Updated: Feb 21, 2013 at 11:49 PM by rich_mccloud | Created: Apr 27, 2010 at 9:30 PM by christianbolton