Post reply

Reduce Logical reads

  • February 19, 2014 at 4:20 pm

    #304335

    In our production server, views were slower in execution. So I optimized couple of views by removing functions from select clause and using joins as needed. Optimized view was 3 times faster than old views. After deploying this view in production, standalone view execution was faster, but when it was joined with other views, it turned out to be slower and when old view was joined with same other views, performance was much better than the optimized views. Using Statistics IO ON, I found that logical reads in optimized view were significantly more than the old one. So I am not able to make out if standalone optimized view is faster than old view, then with joins with other view, makes same view slower than the old views. Could someone please advise me how to reduce logical reads?

  • February 19, 2014 at 4:25 pm

    #1690507

    There's not enough information on what's happening. The problem is too generic and can't be solved.

    For performance problems, check the following article:http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • February 20, 2014 at 12:31 am

    #1690554

    Reducing the logical reads involves tuning indexes and query. That's about all that can be said without further information.

    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 3 posts - 1 through 2 (of 2 total)

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