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 |
|
Mazdak
Yak Posting Veteran
63 Posts |
 Posted - 2002-11-01 : 13:46:08
|
| How can I make SQLServer trace profiler auto start?I want to create trace and make it available when ever SQLServer starts and log those events. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-11-01 : 17:12:29
|
| I don't think that you can get SQL Profiler to do what you want it to do. Why would you want to start a trace every time SQL Server starts? SQL Profiler should only be used when you need it because it causes some performance problems (mostly minimal problems but that depends on how many events you are tracing). |
 |
|
|
Mazdak
Yak Posting Veteran
63 Posts |
Posted - 2002-11-02 : 09:17:13
|
| Maybe I need to do some trace when I'm not present at SQLServer.Is it some think that never happend? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-11-02 : 09:23:17
|
| OK then, what is it exactly that you want to trace? Is it only going to happen at startup? There is a great deal of information in the SQL Server logs every time the service starts, what else do you need to trace?I agree with tduggan. Without more detail on what you're trying to do, it doesn't make a lot of sense to run Profiler at startup. |
|
|
|
rkc01
Starting Member
43 Posts |
Posted - 2002-11-02 : 13:23:24
|
| You can schedule traces as jobs through the sql agent. Look in BOL, it has everyting you need to get you started. |
|
|
|
Mazdak
Yak Posting Veteran
63 Posts |
Posted - 2002-11-02 : 14:44:52
|
quote:
You can schedule traces as jobs through the sql agent. Look in BOL, it has everyting you need to get you started.
To do that I have to write some command in job setting,but what is command for that?I don't want to trace anything now,but I'm curious to know how to do that. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-11-02 : 15:25:39
|
| Did you look in Books Online? |
|
|
|
Mazdak
Yak Posting Veteran
63 Posts |
Posted - 2002-11-03 : 15:03:13
|
quote:
Did you look in Books Online?
Yes,but I can't find about what what you say. |
|
|
|
|
|
|
SQLServer profiler