You can save a trace from SQL Profiler as a Trace Table, which you can
then query to your hearts content.
To identify deadlocks, you need to ensure that your original trace
includes Lock events (such as Lock:Deadlock), which are not included in
the default trace properties.
To identify long lasting queries, you can filter for durations exceeding
a specified number of seconds. For more granular searches, you can
include SP:Completed and SP:StmtCompleted, both under Stored Procedures.
TC
-----Original Message-----
From: Emer Ryan
[mailto:mssqldba-ezmlmshield-x59636661.[Email address protected]
Sent: Friday, July 29, 2005 2:40 AM
To: LazyDBA Discussion
Subject: how to read performance levels through a trace file & server
log
Hi
I need to ascertain slowness on our databases by using the sql profile
trace to trace all activity,
How can I open up these traces and how to identify the issues
& secondly if I was to read the logs where would I start seeing the
'deadlocks' and slowness in the database?
Cheers
E
________________________________________________________________________
****************************************************************
Charter UK provides customer intelligence software for consumer affairs
professionals, customer service managers and marketing strategists.\par
Established with 14 years experience in Customer Experience Management
(CEM), Charter UK promotes public sector and corporate best practice
through the proactive management of feedback across all communication
channels.\par The company's flagship product, Charter Continuum (TM),
provides organisations with a corporate-wide solution for managing all
forms of feedback in one integrated and centralised system for true
competitive advantage. Charter software and services improve customer
loyalty, increase customer retention and provide a rapid return on
investment.\par Charter Continuum (TM) incorporates the powerful,
customisable reporting capabilities of Business Objects (R) for customer
experience management and trend evaluation for business process
improvement. Charter Continuum (TM) incorporates a flexible diary
management system and call-logging wizard for the management of customer
intelligence, feedback data capture and analytics.\par Join the
world-class companies using the Charter brand of products and services
such as McDonalds Restaurants, Starbucks Coffee, Staples, Rowenta and
First Choice. For more information on how Charter can enhance your
corporate performance visit www.charter-uk.com \par
*****************************************************************
________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet for
Charter UK. The service is powered by MessageLabs. For more information
on a proactive anti-virus service working around the clock, around the
globe, visit:
http://www.star.net.uk
________________________________________________________________________
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page