Performance

Question

Post reply

Performance

Mvs2k11

Ten Centuries

Points: 1223
More actions
February 13, 2013 at 7:11 pm

#270815

I got the saved sql profiler trace file from DBA team for performance and would like to know the
SQL Trace results wtih conclusion.
Please provide me suggestion what i need to look for the performance.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 1

Hi,

You should look at CPU, Reads, Writes, Duration and the TextData.

IgorMi

Igor Micev,My blog: www.igormicev.com

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass