Viewing 15 posts - 736 through 750 (of 1,127 total)
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
oh..i see your point.I didnt really make a note before i changed the setting but now i can see that sql is using only 32 mb of 43 gb. However...
January 19, 2011 at 8:59 pm
Viewing 15 posts - 736 through 750 (of 1,127 total)