profiler

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » profiler

profiler

Rate Topic

Display Mode

Topic Options

Author

Message

samsql

Posted Wednesday, October 22, 2008 7:23 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, March 21, 2013 5:40 AM
Points: 288, Visits: 517

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

Jack Corbett

Posted Wednesday, October 22, 2008 7:54 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 3:07 PM
Points: 10,613, Visits: 11,959

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

DNA_DBA

Posted Wednesday, October 22, 2008 8:05 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 7:16 AM
Points: 2,376, Visits: 1,958

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 »

Permissions