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

Compare the efficiency of the two mining processes, Consider the following ... Consider the following database containing five transactions. Let min_sup = 60%. Mine all frequent itemsets using Apriori and FP-growth algorithm. Compare the efficiency of the t

Describe domain constraints, Describe domain constraints. Domain constr... Describe domain constraints. Domain constraints contain entity integrity and referential integrity. The domain is a set of values that might be assigned to an attribute. The en

What is a homogeneous distributed database, What is a homogeneous distribut... What is a homogeneous distributed database? In homogeneous distributed databases, all sites have the same database management system software, are aware of one another, and agr

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

Database design, Why is database design important? Why is database design important?

Having clause-data manipulation language, Having clause This clause... Having clause This clause is used for producing conditions on grouped information. Example: Find maximum salary and department number of those departments where maxim

Explain nested relations, Explain nested relations? Nested relations ... Explain nested relations? Nested relations The assumption of INF is a natural one in the bank examples we have considered. However, not all applications are best modelled

Relation and relational schema, A relation has: Relational Schema ... A relation has: Relational Schema Relation instance Relational Schema: A relational schema shows the relation's name, its attributes and the domain of every a

Difference between operating system and database security, Difference betwe... Difference between Operating System and Database Security Security within the operating system can be executed at various levels ranging from passwords for access to system, t

Serialisable schedules, Serialisable Schedules: If the processes of two tra... Serialisable Schedules: If the processes of two transactions conflict with each other, how to verify that no concurrency related problems have happened? For this, serialisability t