Post reply

improve Performance for update queries and most frequently used queries.

  • July 19, 2014 at 1:39 am

    #288043

    please suggest me some way to improve the performance for the below mentioned type of queries..

    1)How to improve the performance of an update query.The table is having almost only update queries ..very few select queries are run on the table in a day..please suggest me some way to increase the performance.

    2)Also i wouls like to know how to improve performance for simple select queries that are run hundreds of times a day.The query is a simple query (SELECT [abc] FROM [abc] WHERE [date]=@1).Even the table size s very small.

    The basic intention for these questions is that the server is getting slower so i want to increase the performance.

  • July 19, 2014 at 2:53 am

    #1730820

    Answer to both of those is the same. Ensure that the queries can use indexes, ensure that there are index to support the queries.

    See http://www.amazon.com/Server-Query-Performance-Tuning-Experts/dp/1430242035/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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