I tried many event types but could not achieve logging for Linked server. I could figure out events for all other databases but no luck with linked server. Any suggestions ?
I tried many event types but could not achieve logging for Linked server. I could figure out events for all other databases but no luck with linked server. Any suggestions ?
2条答案
按热度按时间ajsxfq5m1#
You can use the
OLEDB_DATA_READ
event to track queries to linked servers. If the results from this event are more verbose than you want, you may need to add filters to capture the the particular information that is needed. The following DDL creates this extended event and adjusting the options (i.e.FILENAME
,MAX_MEMORY
, etc.) will probably be necessary.new9mtju2#
This is just an expansion of @userfl89's answer, with a query to parse the xevent. I needed this, but since I don't need a bunch of history, ran it through a 1mb ring buffer, and the startup_state is off (so it won't restart after a sql service restart). There's two pieces of code - the first is quick & dirty and will probably work well enough. The second batch of code is complicated because I use it for other Xevents that are larger and are really slow otherwise.
Quick & Dirty
And a better-performing version for servers with a ton of calls in the event.