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 |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2003-09-12 : 18:06:41
|
| Hi, PSoft asked to monitor db t-logs to see if anything sticks out while users are running the time-consuming processes. I am thinking running Profiler to monitor the sql stats. Is there any other way to monitor the t-logs? Thanks,Sarat**To be intoxicated is to feel sophisticated, but not be able to say it.** |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-12 : 18:10:45
|
| You can read the transaction log if you purchase Log Explorer from Lumigent. But SQL Profiler would be the tool to use to see what processes are taking a long time. Duration is the column that you would be interested in.Tara |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-12 : 18:15:27
|
| Save the trace to a table, then run this to determine which queries are the longest running queries:SELECT TOP 100 TextDataFROM TraceTableNameWHERE TextData IS NOT NULL and TextData <> ''ORDER BY Duration DESCTara |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-09-12 : 18:50:33
|
| "Sarat" backwards is "Taras"wow!- Jeff |
|
|
|
Sarat
Constraint Violating Yak Guru
265 Posts |
Posted - 2003-09-12 : 19:50:58
|
| God...I never ever noticed that!!That actually means something too!!;-)**To be intoxicated is to feel sophisticated, but not be able to say it.** |
|
|
|
|
|
|
Monitoring T-Logs