Cheryan Jacob

US Patent:

20140019610, Jan 16, 2014

Filed:

Jul 10, 2012

Appl. No.:

13/545365

Inventors:

Rong Wu - Redmond WA, US
Cheryan Jacob - Redmond WA, US
Jerome R. Halmans - Monroe WA, US
Xinwei Hong - Sammamish WA, US
Peter Gvozdjak - Bellevue WA, US
Young Gah Kim - Bothell WA, US

Assignee:

MICROSOFT CORPORATION - Redmond WA

International Classification:

G06F 15/173

US Classification:

709224

Abstract:

A trace identifier is sent between a database client and a database server using a pre-login data package along with pre-login connection open requests through the TDS protocol. The trace identifier gets logged by client-side connection-related traces, by server-side traces, and by database engine traces. The trace identifier can be used to exactly correlate a physical connection on the client to a physical connection on the server. This enhances troubleshooting of the database system, particularly when there are many concurrent users and threads.

US Patent:

20140019478, Jan 16, 2014

Filed:

Jul 10, 2012

Appl. No.:

13/545253

Inventors:

Rong Wu - Redmond WA, US
Cheryan Jacob - Redmond WA, US
Jerome R. Halmans - Monroe WA, US
Xinwei Hong - Sammamish WA, US
Young Gah Kim - Bothell WA, US

Assignee:

MICROSOFT CORPORATION - Redmond WA

International Classification:

G06F 17/30

US Classification:

707770, 707E17014

Abstract:

A trace header with an activity identifier is sent between a client and a database server as part of a request message stream. The activity identifier gets logged by client-side connection-related traces, by server-side traces, and by database engine traces. The activity identifier can be used to exactly correlate a thread on the client to threads on the server. Additionally, specific threads within a database engine may be correlated using the activity identifier to track the threads that processed a particular request. This enhances troubleshooting of the database system, particularly when there are many concurrent users and threads.