InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 07:02:45 GMT20http://www.sqlservercentral.com/Forums/Topic1410969-391-1.aspxAh, I remember the days of DBCC PINTABLE. Those were the days.Kids, dont try that at home, it doesnt work anymore.Mon, 28 Jan 2013 09:45:28 GMTDiverKashttp://www.sqlservercentral.com/Forums/Topic1410969-391-1.aspx[quote][b]GilaMonster (1/24/2013)[/b][hr]Very likely has nothing whatsoever to do with the execution plan. 15 seconds is far longer than SQL takes to compile anything other than a ridiculously complex query.Restarting cleared the data cache, the cache of data pages. After the restart queries have to read the data from disk (slow), not cache (fast). Hence the first run of any query will be slower than the second or third or subsequent runs[/quote]+101st Run = Disk --> RAM --> Client2nd Run = RAM --> ClientFri, 25 Jan 2013 03:16:29 GMTSean Pearcehttp://www.sqlservercentral.com/Forums/Topic1410969-391-1.aspxVery likely has nothing whatsoever to do with the execution plan. 15 seconds is far longer than SQL takes to compile anything other than a ridiculously complex query.Restarting cleared the data cache, the cache of data pages. After the restart queries have to read the data from disk (slow), not cache (fast). Hence the first run of any query will be slower than the second or third or subsequent runsThu, 24 Jan 2013 04:49:53 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1410969-391-1.aspx[quote][b]nishantshende-532951 (1/24/2013)[/b][hr]I think the execution plan is taking much time, so can anyone tell me how to save the execution plan. So that the procedure will take 1 second even after restarting the SQL Server service. Or please share the solution if any.[/quote] your sql restart flushed all the plan from buffer thats y when the SP got executed first time it toook longer time and next time since it found the exec plan available SP got executed faster.memory mangement manage the exec plan storage in buffer cache. thats sql server internal , you dont need to take care of this. but yes right amount of memory(RAM) should be there.Thu, 24 Jan 2013 01:27:57 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1410969-391-1.aspxHi,I have one store procedure which is taking 15 seconds after restarting the SQL Server Service. But when I try to execute the stored procedure from 2nd time, it takes only 0.8 to 1 second.I think the execution plan is taking much time, so can anyone tell me how to save the execution plan. So that the procedure will take 1 second even after restarting the SQL Server service. Or please share the solution if any.Thanks in Advance,Nishant Shende Thu, 24 Jan 2013 01:06:15 GMTnishantshende-532951