Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sun_boat
Starting Member
2 Posts |
 Posted - 2009-07-30 : 00:07:09
|
| Hi,The requirement is for logging the cube usage and recording them into db table.I believe the profiler trace works for it. But because of the permission issue in Production environment, we are denied to use profiler UI to do it directly and I also think it is not a good idea to open a trace all along in profiler. So I tried to use SQL job for it. The Method is demonstrate in details here: http://www.sqlservercentral.com/articles/Profiler/63097/, but unfortunately, again, We cannot use SQL job in PRO ENV.Keep searching, another article attracted me: http://blogs.techrepublic.com.com/datacenter/?p=159, some store procedures like "sp_trace_" can be used for managing the trace. I thought maybe I could use these scripts in SSIS SQL task and conbine them into one package to be scheduled. but I failed again. it seems that this method is for SQL trace while not Analysis service trace. I cannot specify the connection to analysis service for the SQL Task.So guys, could you please give some suggestions about this task. it has really puzzled me so much. Thanks in advance!! |
|
|
|
|
|
On using script to create trace for cube usage