SQL Nexus Tool

Upgrade: New Version of LabDefaultTemplate.xaml. To upgrade your build definitions, please visit the following link: http://go.microsoft.com/fwlink/?LinkId=254563

Checked in by server upgrade

delete backup and build folder

1) New layout to separate 2000,2005, 2008 perf stats reports
2) Additional reports
a. Bottleneck Analysis report now has drill-through report on specific waits
b. 2008 has query hash report
c. 2005 and 2008 both have spin lock report
3) Upgraded to VS 2008 and requires SQL Server 2008 SP1 report viewer control (downloadable from http://www.microsoft.com/downloads/details.aspx?FamilyID=bb196d5d-76c2-4a0e-9458-267d22b6aac6&DisplayLang=en)
4) Login form: <ENTER> will invoke "connect" button automatically
5) Now imports virtual file stats (no report yet)
6) Fix: Current DB dropdown not showing with low resolution
7) Detailed check on reports that don't have data for that specific version

3.0.0.0 release

1. New layout to separate 2000,2005, 2008 perf stats reports
2. Additional reports
a. Bottleneck Analysis report now has drill-through report on specific waits
b. 2008 has query hash report
c. 2005 and 2008 both have spin lock report
3. Upgraded to VS 2008 and requires SQL Server 2008 SP1 report viewer control (downloadable from http://www.microsoft.com/downloads/details.aspx?FamilyID=bb196d5d-76c2-4a0e-9458-267d22b6aac6&amp;DisplayLang=en)
4. Login form: <ENTER> will invoke "connect" button automatically
5. Now imports virtual file stats (no report yet)
6. Fix: Current DB dropdown not showing with low resolution

silent /batch processing
1) Adjusted CurrentDB text box for auto-complete and copy and paste database name
2) Enhanced batch/silent import running from command prompt.
example: sqlnexus.exe" -S"<serverName>" -d"<db Name>" -E -I"<Input file path>" -X -O"output log directory"
a) ability to run silent mode including running under xp_cmdshell
b) allow log directory (-O) to create log file (sqlnexus.000.log) instead of default location (%Temp%)
c) automatically select first instance if data collected from mult-instances.

Other fixes include unable to find post-script "PerfStatsAnalysis.sql"

1) will work on 2008 only machine (without requiring 2005 tools)
2) add SQL Server authentication
3) divide by zero error
4) remove dependency to 2005 SMO
5) Error converting data type varchar to datetime. (.Net SqlClient Data Provider) (2.5.0.6)
6) adding a SQL Server 2000 blocking report (thanks to AmitBan)
7) extract readtrace report during startup
8) Ignore blocking trace files (with *blk.trc file name)
9) Raise error if old version of read80trace is installed

this release fixed three things
1) added text rowsetimport engine that wasn't included in 2.5.0.4
2) added version logging for reporter.exe (readtrace integration)
3) added an option to enable or disable MARS using readtrace (this was turned on by default before. it can cause 0 appended to spids when readtrace does trace importing. for servers that don't use MARS, this can be confusing)

fixed 3 bugs
1) readtrace intergration
2) error Some or all identity references could not be translated.
3) you have provided an illegal table name (likely in your TextRowsetsCustom.xml). consider deleting that file from %appdata%\sqlnexus directory

adding envelopehs.bmp

fixing System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

various changes
validation of reports before rendering
add ignorabl waits
readtrace integratio

release additional source and fixed issue related to finding 64 bit readtrace

add solution file

2.5 release