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 ««12

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


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 3:16 PM
Points: 355, Visits: 1,881
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
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 11, 2014 5:59 PM
Points: 72, Visits: 400
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
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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 »

Add to briefcase ««12

Permissions Expand / Collapse