Post reply

Restore Backup and Performance is Fast...Restore another and it is slow

  • January 10, 2008 at 1:31 pm

    #127501

    This is driving me crazy. I maybe missing something, but here we go:

    We have a product that has a database for each customer. We have 20 customers (so 20 databases) and the databases are under 1 GB with 50,000 records being the most in some of the tables. We set up another database for a new customer on test, load the data, and check it out to production.

    The data analyst/application test techs did not look at the web pages that bring up the user's data. We found that when we restored it to production it was very slow. The amount of data was less than most clients, but every page that pulled data was slow. :w00t:

    We went back and checked test and it was slow, but Profiler or Performance Monitor was not going crazy on any one item. All the other databases were fast (as usual).

    I did a checkdb, rebuild on indexes, and few other things and nothing showed up.

    I backed up test, then deleted the test database including the files. I restored back to test and POOF the database is fast. Pages come up in less a second.

    Now, on Production the clients had been into the system and added more data. I was in a little bit of trouble. I ran checkdb, rebuild indexes..etc. I backed it up, deleted production including files, and now restored the production database. Now production is POOF...fast. Now everyone is happy, but I have no idea what is causing this problem. I have restored test using another backup without deleting the existing database (restore over) and it is slow again. Any ideas of what I could run on the test database to see what is causing the problem???

    Thank you in advance for your time.

  • January 10, 2008 at 1:38 pm

    #766847

    Index Stats.....

    ObjectId FragPercent RecordCount IndexType

    -------------------- ---------------------- -------------------- ------------------------------------------------------------

    SiteP 66.6666666666667 280 CLUSTERED INDEX

    Volume 58.3333333333333 958 CLUSTERED INDEX

    Sites 50 56 CLUSTERED INDEX

    Brands 0 10 CLUSTERED INDEX

    Constraints 0 80 CLUSTERED INDEX

    Groups 0 1 CLUSTERED INDEX

    ProductBack 0 0 CLUSTERED INDEX

    ProductCome 0 4 CLUSTERED INDEX

    Products 0 5 CLUSTERED INDEX

    Recoveries 0 0 CLUSTERED INDEX

    SiteComments 0 0 CLUSTERED INDEX

    SiteComp 0 40 CLUSTERED INDEX

    SitePorts 0 96620 CLUSTERED INDEX

    SiteProdR 0 0 HEAP

    SiteProdR 0 0 NONCLUSTERED INDEX

    SiteResults 0 0 CLUSTERED INDEX

    SiteSettings 0 32 CLUSTERED INDEX

    SitesToGroups 0 16 CLUSTERED INDEX

    SiteStrategies 0 11 CLUSTERED INDEX

    SiteSP 0 0 CLUSTERED INDEX

    SiteGroupings 0 27534 CLUSTERED INDEX

    UsersToGroups 0 4 CLUSTERED INDEX

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply