<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Ian Stirk
»
Get Performance Tips Directly From SQL Server...
36 posts, Page 4 of 4
««
«
1
2
3
4
Get Performance Tips Directly From SQL Server
Rate Topic
Display Mode
Topic Options
Author
Message
ziangij
ziangij
Posted Monday, April 05, 2010 4:13 AM
SSCommitted
Group: General Forum Members
Last Login: Friday, May 17, 2013 2:53 AM
Points: 1,528,
Visits: 359
thanks for the article... it really helped me improving the performance of my query...
Post #896602
terry.bacon
terry.bacon
Posted Friday, April 09, 2010 3:15 AM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, January 24, 2013 4:08 AM
Points: 47,
Visits: 85
Cheers Ian - it's a very useful little SP.
I am also finding it useful in detecting questionable queries - where the indexes for the tables have been planned out, but the sql server is raising issues of missing indexes, because the relevant query isn't written correctly to use indexes that are already in place.
A case of looking at the missing index hint and saying to yourself, "Why do you think you need that?"
Post #900282
ianstirk
ianstirk
Posted Friday, April 09, 2010 6:15 AM
SSC Rookie
Group: General Forum Members
Last Login: 2 days ago @ 6:22 AM
Points: 47,
Visits: 762
Hi Terry,
I think you've raised an important issue here. Sometimes, when we have planned the indexes, rather than blindly impliment the 'missing' index, we should revisit our query instead e.g. maye we have an implicit conversion happening - or indeed our statistics may be old, which will influence the use of the index.
Thanks
Ian
Post #900411
Charan Dhavil
Charan Dhavil
Posted Sunday, May 09, 2010 11:15 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, June 10, 2010 8:24 PM
Points: 1,
Visits: 16
Is this answered? Please let me know how to fix it. Never used cross apply before
Post #918668
r.mitchell
r.mitchell
Posted Friday, June 22, 2012 12:28 PM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, May 17, 2013 12:29 PM
Points: 90,
Visits: 73
Nice utility. Just found some missing indexes on an cached plan that has ran 2 million times. It wasn't the table I thought was missing indexes and haven't touched it in almost 6 months. Good info to find out.
Post #1320149
Lynn Pettis
Lynn Pettis
Posted Friday, June 22, 2012 12:32 PM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 12:11 AM
Points: 21,602,
Visits: 27,431
paul weegar (6/12/2009)
Microsoft also has a FREE reporting tool called dashboard_performance that shows missing indexes, plus a lot more. It runs on SQL 2005 SP2 or above. Here is the link for those that are interested:
http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en
What I would like to know is, how reliable/accurate are the estimations? I ask because I have a large table (2.5 million+ rows). One of the columns is called iscom (have no idea what it is used for, as this database was created from a vendors application) which SQL Server thinks should be indexed for every query. Only problem is the only value in this column is 0. Plus I see that SQL Server reports that it wants indexes included on all fields....
For those who don't like to copy paste:
http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en
Lynn Pettis
For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here
or
when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here
and
here
Managing Transaction Logs
SQL Musings from the Desert
Fountain Valley SQL
(My Mirror Blog)
Post #1320152
« Prev Topic
|
Next Topic »
36 posts, Page 4 of 4
««
«
1
2
3
4
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
