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 |
|
scelamko
Constraint Violating Yak Guru
309 Posts |
 Posted - 2006-07-06 : 10:52:16
|
| Guys,I have 30 machines where my application is installed, each of the machine through the application will access the DB Server. If I want to run profiler to track the network latency from one of these machines do I have to run the profiler from that machine or from the server itself. Does it matter from where profiler run in the event of checking the network traffic.Thanks |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-07-06 : 11:04:29
|
profiler can measure network traffic??didn't know that...Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-07-06 : 11:31:44
|
| why don't you just ping your sever from all 30 systems and look at the response time. That will give you your latency information.SQL Profiler will not give you any network information, so there is no point in running it.-ec |
|
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-07-10 : 02:41:58
|
| Hey Brett, I know from before (and read from others) that running SQL profiler on the actual SQL server machince is a bad idea, since it'll need to keep update the UI and will take resources. MS recommanded to use server-side trace instead, since it'll be running on the server, but then I got a qn now, since running a server-side trace is like running a profiler on the server without the UI, is it that much impact on the UI and slow down that much? haven't really tried it myself, so just wondering if anyone tried it can let me know.Thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-10 : 12:23:10
|
| I have significantly increased the CPU utilization on the database server when running SQL Profiler on it. I didn't realize I was on that box until things really started to slow down.Tara Kizeraka tduggan |
|
|
|
|
|
|
SQL Profiler