分析服务实时跟踪日志
我希望实时获取 AS 的跟踪日志(与 SQL Server 相同)。我找不到任何 .net 接口。到目前为止,我能想到的唯一现实的解决方案是永久运行它并将其转储到一个新表,我通过触发器监听更新。
有谁知道更好的方法来做到这一点?
这是我想要的数据(全部): http://msdn.microsoft.com/en-us/library/ms174901%28SQL.90%29.aspx
I'm looking to get the trace logs for AS (same stuff as for SQL server) in real time. I can't find any .net interfaces to this stuff. So far the only realistic solution I can think of is to run it permanently and have it dump to a new table which I listen to on updates via triggers.
Does anyone know of a better way of doing this?
This is the data I'm after (all of it): http://msdn.microsoft.com/en-us/library/ms174901%28SQL.90%29.aspx
Ta
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
以下是 API 参考:
http://technet.microsoft.com/en -us/library/microsoft.analysisservices.aspx
您可以设置使用分析管理对象中的跟踪来捕获事件。以下是一些示例代码:
http://www.sqlserverdatamining.com /ssdm/Default.aspx?tabid=102&Id=18
希望这是一个开始。
Here's the API reference:
http://technet.microsoft.com/en-us/library/microsoft.analysisservices.aspx
You can setup to capture events using Trace in the Analysis Management Objects. Here's some sample code:
http://www.sqlserverdatamining.com/ssdm/Default.aspx?tabid=102&Id=18
Hope this is a start.