C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Murali (143)
Bunty (130)
Deepika Harida... (129)

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

SQL Profiler

Posted Date: 17 Jun 2008 Resource Type: Definitions Category: General

Posted By: Phani Member Level: Silver
Rating:

Points: 2

SQL Profiler is a graphical tool that allows system administrators to monitor events in an instance of Microsoft SQL Server. You can capture and save data about each event to a file or SQL Server table to analyze later. For example, you can monitor a production environment to see which stored procedures are hampering performance 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 want, 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 large, especially when the monitoring process takes place over a long period of time.

Responses

Author: Bunty 21 Jun 2008

Member Level: Diamond Points : 2

Hi,
Nice attempt to clarify what exactly SQL profiler is.
You can add more about SQL profiler.
It's a nice tool available in SQL Server.
Thanks for sharing your knowledge.

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Trigger
	Previous Resource: Log shipping
	Return to Discussion Resource Index
	Post New Resource
	Category: General

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

silicone halloween mask