Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Performance Expand / Collapse
Author
Message
Posted Wednesday, February 13, 2013 7:11 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, March 9, 2016 2:55 PM
Points: 69, Visits: 91
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.
Post #1419796
Posted Thursday, February 14, 2013 1:28 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 1:00 AM
Points: 3,833, Visits: 4,408
Hi,
You should look at CPU, Reads, Writes, Duration and the TextData.

IgorMi




Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1419860
Posted Thursday, February 14, 2013 1:46 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:38 PM
Points: 44,898, Visits: 42,919
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

Post #1419870
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse