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

I need helpin assignment, My cut off date is very soon in a Database subjec... My cut off date is very soon in a Database subject and i dont know how to solve anything in it

Define the unique constraints for the table client, Define the following co... Define the following constraints for the table client. (i) BAL_DUE must be at least 1000. (ii) NAME is a unique key. (i)ALTER TABLE CLIENT ADD CONSTRAINT CLIENT_BAL_DUE_C1

Create the logical database schema, 1.  Based on the dependency diagram, cr... 1.  Based on the dependency diagram, create a database whose tables are in at least 2NF, showing the dependency diagram for each table (as shown in class).  Label the types of depe

Managing database, 10A.53 Code an Oracle Database trigger to enforce the ... 10A.53 Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department. 10A.54 Code an Oracle Database trigger to allow the

Explain projection operation distribute over union operation, Illustrate th... Illustrate the statement 'Projection operation distributes over the union operation'. Give an example.    Ans: Π L (E 1 ∪ E 2 ) = (Π L (E 1 )) ∪ (Π L (E 2 ))   This says th

Designing a Human Resources Database LASA1, Scenario: You are a freelance ... Scenario: You are a freelance database designer who has just been contacted by a small software development company named Altair Software. The president of the company has asked

What is data definition language, What is data definition language? Explain... What is data definition language? Explain it in detail? The SQL DDL allows specification of not only a set of relations, but also information after each relation, containing

What is a phantom deadlock, What is a Phantom Deadlock? In distributed... What is a Phantom Deadlock? In distributed deadlock detection, the delay in propagating local information might cause the deadlock detection algorithms to recognize deadlocks

How can you terminate the mysql server, How can you terminate the MySQL Ser... How can you terminate the MySQL Server? Typing the following in Command prompt will shut down the server completely as root user % mysqladmin -u root -p shutdown

Discuss the count function, Discuss the count function? The COUNT funct... Discuss the count function? The COUNT function used returns the number of tuples or values fixed in a query. The count function comprises two types of syntax: (1) COUNT (*)