• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 291
  • Last Modified:

Run profiler on seperate server.

I know that SQL Profiler take a lot of resource....

If I were to run the SQL Profiler on a separate server would this make any difference ...

For example run profile on Development server which monitors the Production Server?
0
Mr_Shaw
Asked:
Mr_Shaw
  • 4
  • 3
1 Solution
 
vinurajrCommented:
better to run the Porfiler from other system:
1) avoid running profiler for long time.(run only when required)
2) try to use server trace.(Sample File Attached)

Trace.txt
0
 
Mr_ShawAuthor Commented:
Will it have to same performance impact running from another machine?
0
 
vinurajrCommented:
Performance Impact is there always its an overhead for the SQL Server: because this need to track all the Transaction. Running a visual tool from the same server means its an over Head for the Server system. If you run from the other system then resource taken to execute the visual tool execution is moved to that system thats it.
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Mr_ShawAuthor Commented:
sorry to ask another question:

To confirm running SQL profile on Dev server which monitor the Production Server should have little or no impact on the performance of the Production server?
0
 
vinurajrCommented:
As I am telling again there will be less Impact while running from DEV server than Production server if u are running the visual tool. Still when required only execute(avoid running) the Profiler from DEV server.
0
 
vinurajrCommented:
avoid running for hours in a heavy load Production server.
0
 
Mr_ShawAuthor Commented:
Thanks..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now