Timeline for Audit user queries on SQL Server 2005
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 22, 2012 at 2:22 | comment | added | WT_W | Thanks @Marian. I have used trace events at least in the short term, because it can capture the cache insert and cache miss events. As we're primarily worried about ad hoc queries, this will presumably capture at least the first instance of the query being run. If the hit rate is too low we'll bump it up to server side traces. | |
| Nov 22, 2012 at 2:15 | vote | accept | WT_W | ||
| Nov 15, 2012 at 10:54 | history | answered | Marian | CC BY-SA 3.0 |