Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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, January 29, 2014 10:02 PM
Points: 60, Visits: 79
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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 5:32 PM
Points: 2,978, Visits: 3,008
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-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:09 PM
Points: 39,968, Visits: 36,327
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 2008, MVP
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