Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mmkrishna1919
Yak Posting Veteran
95 Posts |
 Posted - 2013-05-30 : 09:09:34
|
| Hi All,I opened sql server 2008 profilerClick on the File--->New trace and then Connect to the data baseTrace properties window opened,in the Events Selection tab under stored procedures event category i didn't find "SP:ExecContextHit" event.How can i find this event or isn't available in 2008 profiler?Thanks...M.MURALI kRISHNA |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-05-30 : 09:21:44
|
| Quoting from MSDN:Beginning in SQL Server 2005, SP:CacheHit replaces SP:ExecContextHit, which was used in SQL Server 2000 to indicate that a stored procedure was found in the cache. In later versions of SQL Server, users can expect to see SP:CacheHit in their traces instead of SP:ExecContextHit.http://msdn.microsoft.com/en-us/library/ms179352(v=sql.100).aspxEditing: Clicking on that link takes you to the 2012 page. Copy and paste that URL and it will take you to the 2008 page. |
 |
|
|
mmkrishna1919
Yak Posting Veteran
95 Posts |
Posted - 2013-05-30 : 09:49:31
|
| As "SP:ExecContextHit" this event indicates additional time/resources to locate execution plan in the cache.if cachehit replace ExecContextHit then how can we distinguish these two cases?1.Fully qualified data base object name(identify the Plan directly from cache)2.Unqualified data base object name(identify the Plan with additional time/resource from cache)Thanks...M.MURALI kRISHNA |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-05-30 : 10:57:03
|
| The EventSubClass column (see the same page I referred to earlier) distinguishes between execution context hit and compiled plan hit. I don't know the details of what each of these represents though. |
|
|
|
|
|
|
Profiler issue