Databas performance Issue

Discussion in 'Databases' started by shafiq, Apr 25, 2012.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. i have posted a ticket about my data base performance...i got this replay
    "
    I run the stored procedure you provided in your database and found out that the issue is indeed isolated to your database. It took 2,500ms for the query to run in sql server, which is very high for this simple query. Please see the screen shot attached. You need to optimize your database and/or query to increase the performance
    "
    Now what i should do with my database?
     
  2. Follow the advice you've already been given: "optimize your database and/or query to increase the performance". Doing this includes this non-exhaustive list of options: data removal, schema normalization, schema de-normalization, index rebuilding, index reorganization, index creation, others..

    Only you know how your database is designed and how it's used by your application so the optimization methods you choose to use will have to be tailored to the behaviour of your application and it's database.
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page