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

profiler Expand / Collapse
Author
Message
Posted Wednesday, October 22, 2008 7:23 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, February 06, 2014 5:18 AM
Points: 290, Visits: 524
Wen I m using profiler some of the query running show me cpu 234 ,read 5678, duration 32
i want some of ur suggestion

counters
cache hit ratio 66 % and
buffer cache hit ration 99.86%

28 GB ram
3 ghzprocessor
Post #589785
Posted Wednesday, October 22, 2008 7:54 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:31 AM
Points: 10,910, Visits: 12,548
Looks like you should be tuning those queries.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #589815
Posted Wednesday, October 22, 2008 8:05 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 4:03 PM
Points: 2,564, Visits: 2,192
You can use the 'tuning' trace template in profiler to capture the queries and then you can load the trace file into the Database Tuning Advisor - this may help find missing indexes. Otherwise you can look at the execution plans for the offending queries and see where the problem is.
Post #589824
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse