February 23, 2012 at 10:00 am
If you have performance problems and you suspect that it may have to do with Index usage or anything related to indexes what are some of the DMV's and other tools that you can use to quickly identify the problem and well as analyze and monitor over a period of time?
Listed below is a good article on Index related DMV's.
http://www.sqlserver-dba.com/2011/05/top-5-sql-server-dmv-for-index-analysis.html
Does anyone have any tips on this?
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 23, 2012 at 11:12 am
I often look at the query plan to see what indexes it is using and if they make sense..
CEWII
February 23, 2012 at 12:36 pm
Yep, if I suspect a code or structure problem with a query, it's off to the execution plan.
Now, you can query the cache directly. I've posted a few examples over at the blog. Here's one[/url]. With that, you could try looking for index scans instead of seeks or other stuff along those lines.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 23, 2012 at 4:08 pm
Thanks for the tips!
Have a good day.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply