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 |
|
cherie
Starting Member
46 Posts |
 Posted - 2004-10-17 : 23:46:48
|
| hi...May i know how to use the SQL Profiler to test the performance of my system so that i can know how much times it takes get,serach,delete or update the records in the database??Urgently need help...Regards,Cherie |
|
|
hgorijal
Constraint Violating Yak Guru
277 Posts |
Posted - 2004-10-18 : 01:55:16
|
| track the "Duration" Data Column in profiler for "SQL:StmtCompleted" and "RPC:Completed" Events.Hemanth GorijalaBI Architect / DBA...(yuhoo!!! and now, an "Yak Master")Exchange a Dollar, we still have ONE each.Exchange an Idea, we have TWO each. |
 |
|
|
cherie
Starting Member
46 Posts |
Posted - 2004-10-18 : 02:42:44
|
| hi...i'm a sql profiler beginner...when i create a trace and run my system..the duration will be displayed in the trace..when i searh for a record in the system,it does not show duration.duration will only be show when add or delete is committed..why is it happen??I thought sql profiler is used to save the total amount of time the data use to delete,add, or search from the system to server and then back to the system again???regards,cherie |
|
|
|
hgorijal
Constraint Violating Yak Guru
277 Posts |
Posted - 2004-10-18 : 02:56:01
|
"Duration" is displayed for "Select", "Insert" , "Update" and any other SQL Stetement?quote:
when i searh for a record in the system,it does not show duration.
What do you mean by "search"? Are you using a "Select"? Then the duration will be displayed (in the "SQL: Stmt Completed" event. Are you not seeing it? quote:
I thought sql profiler is used to save the total amount of time the data use to delete,add, or search from the system to server and then back to the system again???
Do you mean, the time it takes from you hit the "Execute Button" to the time it completes displaying the resuts? Then the answer is NO. Profiler will only trace the time SQL statement took to actually execute on the server. Communication and Network delays are not tracked in profiler. you need to track those from your application, say using a getdate() before and after executing the SQL statement. Does that answerHemanth GorijalaBI Architect / DBA...(yuhoo!!! and now, an "Yak Master")Exchange a Dollar, we still have ONE each.Exchange an Idea, we have TWO each. |
|
|
|
cherie
Starting Member
46 Posts |
Posted - 2004-10-19 : 01:46:51
|
| hi..ok..thankx a lot for helping :)regards,cherie |
|
|
|
|
|
|
|
|
SQL Profiler