Viewing 15 posts - 736 through 750 (of 1,129 total)
i was able to generate execution plan using Show XML Statistics Profile,however the execution plan from management studio is little from the execution plan captured in trace. Any idea?
January 22, 2011 at 10:27 pm
GilaMonster (1/22/2011)
Did you clear the proc cache before testing? If not, the proc could have been there from earlier executions
No i did not, i cant clear because i am using...
January 22, 2011 at 6:26 pm
GilaMonster (1/22/2011)
What does the usecounts column say? If it says 3 then the procedure was executed 3 times. If it says 1 then the procedure was executed once.
As you...
January 22, 2011 at 12:24 pm
just an fyi, for each security update and CU the version number will change.
January 22, 2011 at 12:22 pm
arussell_10 (1/21/2011)
sqldba_icon,
The dev server I have already has SP3 and the security update installed, but I didn't do the installs. I don't have another place...
January 21, 2011 at 2:55 pm
GilaMonster (1/21/2011)
sqldba_icon (1/21/2011)
My goal is to findout how many different plans are genrated for each procedure.
One and only one. A procedure can only have one plan in cache at a...
January 21, 2011 at 2:42 pm
arussell_10 (1/21/2011)
I just started at a new company and need a way to determine which patches have been installed on a server. My dev box and Production cluster are...
January 21, 2011 at 1:43 pm
GilaMonster (1/21/2011)
I still don't understand why you're interested in that. An execution plan takes up the same amount of space whether it's used once or 10000 times.
OK i have my...
January 21, 2011 at 1:29 pm
ok..you are right..since it is going to be reusing the same. Thanks for correcting. I am developing a script from the views which you have mentioned, will get back. Thanks
January 21, 2011 at 9:49 am
GilaMonster (1/21/2011)
The DMVs you'll need for this are
sys.dm_exec_cached_plans (one row per plan)
sys.dm_exec_query_stats (one row per statement in...
January 21, 2011 at 8:52 am
ok, i have this query to find some data related to cache. My goal is to find out what procedures are in cache for a specific database and i would...
January 20, 2011 at 3:47 pm
We have dashboard reports installed on all our production servers, Comes very handy, i liked the schema change report ):
January 20, 2011 at 1:19 pm
SQLkiwi (3/21/2010)
Roust_m (3/21/2010)
name,MB used
SQL Plans,6356.898437
Object Plans,378.179687
It looks like SQL Plans are using the most of it. So I guess I do...
January 20, 2011 at 10:22 am
We have isloated reports from our transaction environment. My guess is there is a procedure which is executed like 100 times day and is creating a execution plan everytime. How...
January 20, 2011 at 9:43 am
Viewing 15 posts - 736 through 750 (of 1,129 total)