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 |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2005-07-01 : 10:25:21
|
| Does anyone use Traces?I've never done it. Is it a practical tool? I see it's still in 2005.I sort of understand the concept of re-running a trace and comparing it - but that's where my knowladge ends.Has anyone found that using traces is a good way to debug? |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-07-01 : 10:34:15
|
| I use profiler on fairly regular basis. It takes some practice and I would read the BOL stuff on it. Often I will use it in conjunction with Windows Performance Monitor when things can not be figured out otherwise.What are you trying to do?Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me though the forum. |
 |
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-07-01 : 10:39:13
|
| Just making sure I'm not missing out on using a good tool and saving myself time. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-07-01 : 14:00:58
|
| Profiler has a lot of good uses.You can capture the actual workload on your server into a database table and use it to optimize performance. You can run the Index Tuning Wizard against this table to see if it recommends new indexes.You can look at the stored procedures being called to see which ones are consuming the most resources. I have a script that I run against Profiler output that identifies the procedures being called, how much CPU time they are consuming, and the percentage of the whole that each uses. It is fairly typical that a small number of procedures consume most resources, so if you optimize just a few procedures you can make a huge impact on overall system performance.You can also use it to identify application problems. A programmer may think they are calling the procedures correctly, but you can look at what they are actually sending to the server to see if there are errors. Or maybe find the application is going into a loop and issuing thousands of procedure calls. CODO ERGO SUM |
|
|
|
|
|
|
Does anyone use Traces?