mutley1
MIS
- Jul 24, 2003
- 909
Sorry guys,
Wasn't sure if this was a setup / admin or programming question. I have a tdf file that will basically run to collect data for any SP's / TSQL statements that run for over 5000ms, DBID above 4 and objectid > 100.
The events are ONLY SP: Stored Procedure Completed and TSQL: SQL StmtCompleted.
I am running this from a dev server to collect info from the live server, and the data is being stored on the dev server in a table.
Eg. DEV1\d:\myfolder holds the tdf file. This will run on DEV1 but report on PROD1 with given criteria. It will write to DEV1..DBAdmin.resultstable.
question is, I am running ths manually at the moment so every time I put the right server to trace and the server / table to store data to I am going to overwrite whatever is there (or create loads of tables).
Long and short is I would like to run this for maybe a week at a time, but automate it and still write to the same table to keep all history. I have scripted it out using the tools in SQL Profiler, but it does not point to a server / table or anything (bear in mind I am running from DEV to gather PROD info and writing to DEV).
Any help much appreciated.
Cheers,
M.
Wasn't sure if this was a setup / admin or programming question. I have a tdf file that will basically run to collect data for any SP's / TSQL statements that run for over 5000ms, DBID above 4 and objectid > 100.
The events are ONLY SP: Stored Procedure Completed and TSQL: SQL StmtCompleted.
I am running this from a dev server to collect info from the live server, and the data is being stored on the dev server in a table.
Eg. DEV1\d:\myfolder holds the tdf file. This will run on DEV1 but report on PROD1 with given criteria. It will write to DEV1..DBAdmin.resultstable.
question is, I am running ths manually at the moment so every time I put the right server to trace and the server / table to store data to I am going to overwrite whatever is there (or create loads of tables).
Long and short is I would like to run this for maybe a week at a time, but automate it and still write to the same table to keep all history. I have scripted it out using the tools in SQL Profiler, but it does not point to a server / table or anything (bear in mind I am running from DEV to gather PROD info and writing to DEV).
Any help much appreciated.
Cheers,
M.
