We are tracking top issues here. Please visit this page before posing
Id #25257 | Release:
| Updated: Mar 11 at 9:59 PM by jackli | Created: Mar 11 at 6:54 PM by jackli
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:
| Updated: Feb 21, 2013 at 11:49 PM by zokrc | Created: Feb 23, 2012 at 4:59 PM by WaldiMen
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:
| Updated: Feb 21, 2013 at 11:49 PM by Norberto2021 | Created: Mar 9, 2011 at 11:51 AM by bimaldave
Where is StartSQLDiagTrace command file in 18.104.22.168 which is used to start trace and collect data? I could not find it.
Any help will be appreciated.
Id #20013 | Release:
| Updated: Feb 21, 2013 at 11:49 PM by amitban | Created: Feb 14, 2011 at 6:41 PM by usxg049
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:
Id #19940 | Release:
| Updated: Feb 21, 2013 at 11:49 PM by amitban | Created: Feb 7, 2011 at 7:32 PM by gsprague
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:
| Updated: Feb 21, 2013 at 11:49 PM by amitban | Created: Jan 6, 2011 at 8:00 PM by Feleryan
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:
| Updated: Feb 21, 2013 at 11:49 PM by amitban | Created: Dec 21, 2010 at 5:07 PM by tariqrazzaq
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 22.214.171.124 release
| Updated: Feb 26, 2013 at 10:28 AM by s_osborne2 | Created: Dec 16, 2010 at 2:07 PM by jmkehayias
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: 126.96.36.199
I researched into this since I used this report frequ...
Id #19079 | Release:
| Updated: Jun 14, 2013 at 7:28 AM by amitban | Created: Nov 9, 2010 at 11:32 AM by ecce2k
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:
| Updated: Feb 21, 2013 at 11:49 PM by rich_mccloud | Created: Apr 27, 2010 at 9:30 PM by christianbolton