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: Monday, November 3, 2014 2:59 AM
Points: 313, Visits: 538
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 @ 1:42 PM
Points: 10,340, Visits: 13,341
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:47 AM
Points: 2,717, Visits: 2,335
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