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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2010-10-19 : 01:28:36
|
| Hi AllOn my production database i need to put the pro-filer to trace the events related to intermittent slow during business hours.My concerns here is to which shouldn't slow the server performance because of profiler on production server and which are events should i consider in the profile.? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2010-10-20 : 03:51:39
|
| Thanks Tara.I have one more doubt here..I am using SQL server 2005 with Enterprise edition with SP2.I have used default template sql server profiler "TUNNING" there was a column with Duaration what is the unit it shows is that in SECOND ??Thanks,Gangadhar |
 |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2010-10-20 : 05:18:39
|
| The duration column is milliseconds. 1000 ms =1 second.Mike"oh, that monkey is going to pay" |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL profiler usage