Management studio

• SQL_DBA_3

  SSCarpal Tunnel

  Points: 4772

  More actions

  March 23, 2009 at 11:19 pm

  #132175

  1)When you open a new query window in the Management studio ,why does the first query takes too much time(almost 10 times the actual execution time)

  2)When you expand the databases or tables in the object explorer,why does it takes too much time for the first time?Later on it'll be faster.

  What happens in the background???

• raj acharya

  SSCrazy

  Points: 2805

  More actions

  March 24, 2009 at 1:19 am

  #964989

  i think when we open that first time then that goes into cache...and second time it may be reuse that from cache...this is my simple thought...

  Raj Acharya