best way to log all sql queries?

From: <mh_at_pixar.com>
Date: Mon, 04 Feb 2008 22:39:24 GMT
Message-ID: <wuMpj.2904$uE.2518@newssvr22.news.prodigy.net>

We have a database where users can make ad hoc queries. I would like to be able to log all queries and dml for this database, so that we can have some insight into how the database is being used, and for performance forensics, etc.

What's the best way to do this?

Many TIA!
Mark

-- 
Mark Harrison
Pixar Animation Studios

Received on Mon Feb 04 2008 - 16:39:24 CST

This message: [ Message body ]
Next message: michael.young_at_paetec.com: "substrb and MBCS"
Previous message: Mike: "Req: DBA's Required in VA"
Next in thread: DA Morgan: "Re: best way to log all sql queries?"
Reply: DA Morgan: "Re: best way to log all sql queries?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message