?
Solved

Run profiler on seperate server.

Posted on 2011-02-18
7
Medium Priority
?
284 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 

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 2000 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Suggested Courses

850 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