What is SQL Profiler?

SQL Profiler is a graphical tool that permits system administrators to monitor events in an instance of Microsoft SQL Server. You can capture and save data about every event to a file or SQL Server table to analyze later. For instance, you can monitor a production environment to see which stored procedures are hampering performances by executing too slowly.

Use SQL Profiler to monitor only the events in which you are interested. If traces are becoming too large, you can filter them based on the information you require, so that only a subset of the event data is collected. Monitoring too many events adds overhead to the server and the monitoring process and can cause the trace file or trace table to grow very huge, especially when the monitoring process takes place over a long period of time.

 

Posted Date: 7/10/2013 4:08:49 AM | Location : United States

Ask an Expert

Related Discussions:- What is sql profiler, Assignment Help, Ask Question on What is sql profiler, Get Answer, Expert's Help, What is sql profiler Discussions

Write discussion on What is sql profiler
Your posts are moderated

Write your message here..

Related Questions

Write a short note on built in function in qbe, Write a short note on built... Write a short note on built in function in QBE? Built in function in QBE: QBE involves various built in functions like AVG, MAX,MIN,SUM and CNT. We must prefix these operator

Equi join-table handling, Equi Join: A join in which the joining condition... Equi Join: A join in which the joining condition is based on equality among values in the common columns. Common columns show (redundantly) in the result table. Let us Consider th

Compute natural join and outer join, For the relations R and S given below:... For the relations R and S given below: R                      S A B C 1 4 7 2 5 8 3 6 9

Dataset, The dataset " CFOLYMPICS.XLS " contains the observations used in t... The dataset " CFOLYMPICS.XLS " contains the observations used in the above article.  The definitions of the variables are also included in this spreadsheet.  However, for the purpo

Why do so various organizations use mysql, Why do so various organizations ... Why do so various organizations use MySQL? Advantages: Open source Highly efficient Offers a high scalability in terms of size and connectivity. Highly prote

Define deadlock term, a. Define the term "deadlock". There are four conditi... a. Define the term "deadlock". There are four conditions that must hold before deadlock is possible. Name them. b. Outline an algorithm that detects whether there is a deadlock.

File manager-database management system, File Manager File manager ha... File Manager File manager handles the allocation of space on disk storage. It starts and maintains the list of structures and indices described in the internal schema that is

Defining internal classes and operations, Defining Internal Classes and Ope... Defining Internal Classes and Operations When we enlarge algorithms, new classes can be added to the store intermediate results. A complex operation could be looked at, as a c

What are shortcomings in structured approach, What are shortcomings in stru... What are shortcomings in structured approach? Structured methodology treats data and their behaviours separately, and this makes it harder to isolate changes. If changes are re

Functional Dependencies, What exactly is the concept of Functional Dependen... What exactly is the concept of Functional Dependencies? And how do we associate this concept with the logic of Super-keys, Candidate Keys, etc? Given Relation R(A,B,C,D,E) with de