Help with Database Performance Estimation

        I am trying to put together some sort of prediction as to the amount of slowdown in performance I can expect as our database grows (we expect it to triple very soon). I am particularly interested in cpu time and elapsed time.

        I plan on running the same set of queries several times to come up with a baseline average, then increase the size of the database and repeat the process. Its my hope that the numbers that sql_trace gives me will prove to be a fairly accurate estimation of what we can expect as the production database grows.

I AM concerned that memory buffering will throw off my resulting times.

Does anyone have experience with this sort of testing?

PS: Thanks to everyone who responded to my earlier posting about default dates.

##

                ####              ##       #####    #####    ######  #######
              #######            # #      #        #        #          #
            ##########          ####      ###      ###     #####      #
          ########             #   #        #        #    #          #
        #########             #    #   #####    #####    ######     #
      ===========         =================================================
    ##############      ## Asset Source for Software Engineering Technology
  #########################
  Andrew McConnell         (304)-594-1762         mcconnel_at_source.asset.com

-- 


                 ##

                ####              ##       #####    #####    ######  #######
              #######            # #      #        #        #          #
            ##########          ####      ###      ###     #####      #