Solved

Running SQL Profiler in a live environment

Posted on 2008-06-26
4
254 Views
Last Modified: 2008-09-14
We have an application that is running 24x7 on a Sql Server 2000 SP 1 database.
We wanted to analyze the activities on the live server by turning on the SQL Profiler tool on another server and pointing it to the live database.
There are considerable amount of transactions/queries that are run against the live server.
My question is, how does the SQL profiler affect the performance of a SQL server database and how does it affect the CPU usage of the server?



0
Comment
Question by:mitsdev
4 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 250 total points
Comment Utility
It is minimal..so long as you don't capture a ton of events.  If you're doing the trace through profiler, run profiler on a separate pc that your sql server, just connect to the sql server.  if you store the data, store it to a table on a different sql server or to a file on a different server.
0
 
LVL 7

Assisted Solution

by:60MXG
60MXG earned 250 total points
Comment Utility
Turn on the "Windows Task Manager" and select "Processes" Tab and look at "PROFILER90.EXE" Image Name.  You should be able to see "CPU Time", "Mem Usage", Peak Mem Usage", "VM Size".. and that will give you general idea how much resources are used for this particular process.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
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.
Viewers will learn how the fundamental information of how to create a table.

762 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

10 Experts available now in Live!

Get 1:1 Help Now