March 19, 2013 at 8:39 am
what is query cache plan , list the dmv's to trouble shoot poor performance of a query in sql 2005/2008?
March 19, 2013 at 8:57 am
ramyours2003 (3/19/2013)
what is query cache plan , list the dmv's to trouble shoot poor performance of a query in sql 2005/2008?
1. Google "what is query cache plan" - first link in the search results
http://msdn.microsoft.com/en-us/library/bb738562.aspx
2. Google "sql server dmvs list" - second link in the search results
For some reason, I don't think that my answers will be enough for you to pass through technical interview or exam...
March 19, 2013 at 11:26 am
Sound a lot like interview questions, but since this is hours on...
The cache is where the query plans that have been compiled by the query optimizer are stored in order to reuse them. Not all plans are stored there because plans age out of cache and some plans are never stored there (such as queries with a RECOMPILE statement).
Primarily you want to look at dynamic management views that start with sys.dm_exec_*. Those are the ones primarily used for performance monitoring, but you also have sys.dm_os_wait_stats and others.
"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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy