Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Improving Performance of Logging Tables (Inserts only) RE: Improving Performance of Logging Tables (Inserts only)

  • July 17, 2015 at 2:55 am

    #1813192

    Bharatvip (7/16/2015)

    During the test things start slowing down and that is what is causing concerns.

    Then you need to identify why things are slowing down. What are the bottlenecks? What are the high resource-using queries? Can any tuning be done?

    Trying to fix things when you don't know the cause of the problem will likely be a waste of time.

    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