Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Tip for determining I/O Heavy Queries Expand / Collapse
Author
Message
Posted Friday, March 27, 2009 11:40 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 3:23 PM
Points: 524, Visits: 2,821
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 .





SQL# - http://www.SQLsharp.com/
Post #685263
Posted Tuesday, April 7, 2009 10:34 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, May 27, 2016 10:20 AM
Points: 75, Visits: 416
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
Posted Tuesday, April 7, 2009 1:27 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 19, 2012 10:25 PM
Points: 25, 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 »

Add to briefcase ««12

Permissions Expand / Collapse