Detecting Transaction Isolation Level through Profiler Trace and other means on MS SQL Server 2005

I doubt that this comes up often, but I find myself in a bit of an argument about what isolation level will be used for transactions in our SQL Server database when the transaction is initiated by WebSphere.  There are various documents that indicate how WebSphere can over ride this value.

I decided to dig into this a bit further.

TRACE:

In doing so, I found that I could monitor our SQL Server DB to determine this.

I have only found two places where the transaction isolation level is appearing:
1 - Sessions:Existing Connection.Text Data
2 - In a deadlock trace as part of the XML output.

If anyone can find it elsewhere, I'd love to hear from you.  However, this makes sense, since this is more-or-less controlled at the session level.

QUERY:
If found that 

DBCC USEROPTIONS

would give me the *default* TIL for the db, but that if that TIL was altered by the session, it would not reflect that.

To get the TIL for *your session*, you can run the following query:

SELECT CASE transaction_isolation_level WHEN 0 THEN 'Unspecified' WHEN 1 THEN 'ReadUncomitted' WHEN 2 THEN 'Readcomitted' WHEN 3 THEN 'Repeatable' WHEN 4 THEN 'Serializable' WHEN 5 THEN 'Snapshot' END AS TRANSACTION_ISOLATION_LEVEL FROM sys.dm_exec_sessions

Credit to StackOverflow question and answer here: http://stackoverflow.com/questions/1038113/how-to-find-current-transaction-level 

Starting WebSphere Certification

I'm starting work on my WebSphere certification.
I'm beginning my work with the IBM WebSphere website.

WebSphere main page:
http://www-01.ibm.com/software/websphere/

WebSphere Application Server V8.0 Administration Curriculum:
http://www-01.ibm.com/software/websphere/education/curriculum/appserv/index.html


Several courses are offered.
1 - Administration on Windows
2 - Administration on Linux
3 - Technical Overview
4 - Problem Determination
5 - Transition to V8

I think that this is a good place to start focusing.  No budget to actually TAKE these courses, but this makes a fantastic outline.

The Certification page (http://www-01.ibm.com/software/websphere/education/certification/#free-was-cr) lists quite a few resources as well.

Available certifications include
"IBM Certified System Administrator - WebSphere Application Server Network Deployment V8.0"
The Recommended prerequisite section is telling:

Recommended Prerequisite Skills

(*Knowledge and skills one needs to possess before beginning to prepare for this job role certification; skills not measured on test) 

• basic Java Enterprise Edition 6 knowledge
• basic Web application architecture and deployments
• network and operating system security concepts
• network or operating system administration and problem determination skills
• understanding of operating systems

There is an assessment test which I think will be a very, very useful tool, found here: http://www-03.ibm.com/certify/tests/sam317.shtml.  Cost is $30 / practice test.

There is also a "Training Resources" section (http://www-03.ibm.com/certify/tests/edu317.shtml) that lists several redbooks and Web Resources.

REDBOOKS:
http://www.redbooks.ibm.com/abstracts/sg247957.html?Open
http://www.redbooks.ibm.com/redpieces/abstracts/sg247971.html?Open

There are about a bazillion web resources.  Probably worth checking out.