October 22, 2008 at 7:23 am
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
October 22, 2008 at 7:54 am
Looks like you should be tuning those queries.
Jack Corbett
Consultant - Straight Path Solutions
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
October 22, 2008 at 8:05 am
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply