SQL Server Performance

Application running slow on database.

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by fralo, Dec 15, 2006.

  1. fralo New Member

    Okay, so I have an application that is running slow on a database. I exported specific table data from this db and imported it into another; redirected the application to point to new database. Application now runs smoothly. What do you think caused it to run slow in the old database? The server was just rebooted, so tempdb is not full. I know this is probably a very generic question with a lot of possible suggestions, but I'm just starting to learn sql server, and my knowledge is quite limited. Any help would be greatly appreciated.

    Kevin.

    Kevin Fralick
  2. Luis Martin Moderator

    Did you update full stastitics and/or rebuild indexes as part of maintenance plan?

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  3. fralo New Member

    Actually I think that indexes may be the problem. I originally took a full backup of the original database and imported it into a test environment, which is where my application runs smoothly. Indexes were successfully created in this test environment. However, upon taking an export of certain tables in this test environment and importing them back into the original environment, it appears that the indexes were NOT CREATED! This, of course, would slow down the application queries. I'm now gonna try and re-create those indexes back on this environment and see if performance increases. So it appears that a full backup of a database includes the indexes, but a partial export of selected tables does not include them? Is this correct?

    Kevin.

    Kevin Fralick
  4. Luis Martin Moderator

    "So it appears that a full backup of a database includes the indexes, but a partial export of selected tables does not include them? Is this correct?"

    You have to include indexes when export a table.

    But there is no way with fullbackup or export to translate statistics.
    So after export you must update statistics at least for that table.

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



Share This Page