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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, August 3, 2014 1:58 AM
Points: 312, Visits: 533
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: 2 days ago @ 4:51 PM
Points: 11,264, Visits: 13,023
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: Today @ 6:53 AM
Points: 2,689, Visits: 2,295
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