Dynamics gp inventory

Some Important performance counters / thresholds:

See Common Perfmon Thresholds to Watch subfolder

Performance Analyzer of Logs:

PAL Tool download, training video, and Pre-Requisite linkscan be found at
www.codeplex.com/pal

SQL Nexus:

SQL Nexus download and info can be found at
www.codeplex.com/sqlnexus

Pre-Requisite (RML Utilities / Read Trace)http://sqlnexus.codeplex.com/Wiki/View.aspx?title=ReadTrace&referringTitle=Home
OR
RML Utilities for SQL Server (x86) –http://www.microsoft.com/downloads/details.aspx?FamilyId=7EDFA95A-A32F-440F-A3A8-5160C8DBE926&displaylang=en
RML Utilities for SQL Server (x64) – http://www.microsoft.com/downloads/details.aspx?FamilyId=B60CDFA3-732E-4347-9C06-2D1F1F84C342&displaylang=en

SQLdiag Configuration / CMD files for use withSQL Nexus are a bit hard to find, but they are located on a subpage of the above link. For convenience here is the direct link (look for the 2 version toward the bottom of the web page for SQL 2005 orSQL 2008)
http://sqlnexus.codeplex.com/Wiki/Info.aspx?title=Sql2005PerfStatsScript&action=Info

SQL Profiler Templates:

See SQL 2005 Profiler Templates subfolder

SQL Shadow Table / Triggers:See Shadow Table Trigger subfolder

SQL Blocking Scripts:

See the Blocking Scripts subfolder.

-Run the entire script to build the DB, Tables, and stored procs needed
-Run the statement inthe comments which will continue to run / capture data until you stop the query

Note: The script also creates a SQL job, but I have seen where it randomly stops capturing. Thus, why I suggestmanually running the statement in the comments section of the *.sql script instead.

SQL Deadlocking:

Use the following to record Deadlock information to the SQL Error logs.

dbcctraceon(1204,3605,-1)
dbcc traceon(1222,3605,-1)

Capturing a DexSQL.log:

To turn this on edit the Dex.ini file to change the following 3 lines to TRUE.

SQLLogSQLStmt=TRUE
SQLLogODBCMessages=TRUE...