Tip for determining I/O Heavy Queries

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Ryan Cooper » Tip for determining I/O Heavy Queries

13 posts, Page 2 of 2

««1 2

Tip for determining I/O Heavy Queries

Rate Topic

Display Mode

Topic Options

Author

Message

Solomon Rutzky

Posted Friday, March 27, 2009 11:40 AM

SSC Veteran

Group: General Forum Members
Last Login: Saturday, May 11, 2013 8:33 AM
Points: 285, Visits: 1,376

SanjayAttray (3/27/2009)

Good article, Solomon. Will try to implement it on our siebel server.

Hello Sanjay and thanks. However, the author of this article is Ryan Cooper so he should be getting your compliment Smile

.

SQL# - http://www.SQLsharp.com/

Post #685263

BowlOfCereal

Posted Tuesday, April 07, 2009 10:34 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 2:50 PM
Points: 57, Visits: 317

Hi all,

How do the results gleaned from this setup compare to what's available in the SQL2005 "missing index" dynamic management views?

Post #692275

Ryan Cooper

Posted Tuesday, April 07, 2009 1:27 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, September 19, 2012 10:25 PM
Points: 24, Visits: 316

They would not directly relate at all. This setup uses the size of the index in its calculation to determine the impact of reading it from disk. So, if there is no index, it obviously wouldn't be in this.

However, perhaps, by adding an index recommended by that DMV and reviewed for yourself, you should see a reduction in i/o cost for other indexes related to that table using this method, and hopefully a reduction overall for that table.

Post #692449

« Prev Topic | Next Topic »

13 posts, Page 2 of 2

««1 2

Permissions