Wednesday, March 21, 2012

How can I monitor my SQL?

Hi,

Today, I heard about Sql Profiler, and I seems to be a tool to monitor, analyze, and fine tune sql server. Is there a tool like this for SQL Server Express 2005?

thanks,
John

The SQL profiler comes apart of the SQL Server 2005 developer + editions. It is not available in express but i am sure there should be some free profilers around. You basically use a SQL profiler to see alot of things happening to a database, like viewing authentications, when a stored procedure runs and how often, the time it takes for a procedure to execute. You also can profile things like the broker service, and there is heaps more!

No comments:

Post a Comment