CODEWITHSUNDEEP
sql-serverprofilingmonitoringclient-sideinstrumentation
F.I.V
F.I.V

Reputation: 337

SQL Client Profiler?

I am aware of "SQL Server Profiler", But is there any tools or methods available to monitor the issued sql queries from the client machine?

Some of the things currently in my mind are:

1) The SysInternals ProcMon can log and tell when the executable process on client machine connects to sql server. Any similar but more advanced tools available to tell more data?

2) Any debug version or instrumented version of client libraries and APIs available for client machine to allow such operation?

Upvotes: 0

Views: 1504

Answers (1)

jveazey
jveazey

Reputation: 5468

You can enable ODBC Tracing from the ODBC Data Source Administrator (odbcad32.exe). The log file it generates is rather cryptic but it will provide you with the SQL statements run by the logged in user on that machine. There is also a checkbox labeled "Machine-Wide tracing for all user identities" for logging all SQL statements run by any user - including services - on that machine.

Logging may not start until you disconnect and reconnect to the SQL server. So, it is a good idea to restart whatever programs/services connect to your SQL Server. This is especially important if you have connection pooling enabled, which will keep connections open even if the program, in question, has disconnected.

Also, there are two versions of the ODBC Data Source Administrator on Windows 64bit, one for 32bit and the other for 64bit. So, you will need to enable logging for the appropriate bitness of the program you are tracing.

Update: Another option for you would be to use a tool like Wireshark. Since it has the ability to sit at the network driver level, it can intercept all your network traffic - including but not limited to SQL. These are known as TDS packets - a standard that is used by Sybase SQL Server (ASE), Microsoft SQL Server and FreeTDS ( w/ UnixODBC).

Upvotes: 3

Related Questions