Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning SQL Server 2008 R2 is Sending too much Data through the network RE: SQL Server 2008 R2 is Sending too much Data through the network

  • June 5, 2013 at 2:16 am

    #1621214

    hvermaak (6/5/2013)

    Open profiler,

    File, new trace.

    Connect to your sql server.

    Use the template -> select Tuning

    select save to file -> choose a location with sufficient space

    I would strongly recommend not running Profiler GUI against a production server that's already under load. The GUI can have a severe impact on the target server.

    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