Solved

Run profiler on seperate server.

Posted on 2011-02-18
7
275 Views
Last Modified: 2012-05-11
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
Comment
Question by:Mr_Shaw
  • 4
  • 3
7 Comments
 
LVL 8

Expert Comment

by:vinurajr
ID: 34925046
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
 

Author Comment

by:Mr_Shaw
ID: 34925069
Will it have to same performance impact running from another machine?
0
 
LVL 8

Expert Comment

by:vinurajr
ID: 34925104
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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 

Author Comment

by:Mr_Shaw
ID: 34925386
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
 
LVL 8

Accepted Solution

by:
vinurajr earned 500 total points
ID: 34925489
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
 
LVL 8

Expert Comment

by:vinurajr
ID: 34925494
avoid running for hours in a heavy load Production server.
0
 

Author Closing Comment

by:Mr_Shaw
ID: 34925716
Thanks..
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now