Tuesday, June 25, 2013

Monitor traffic b/w SQL server and front end

I want to monitor SQL traffic b/w Front End and SQL server. What could be the best approach for this ?

Reason :

In our uls logs , we are getting message :

Process : OWSTIMER.EXE (_x-_-_)
Thread ID : _x-_-_
Area : SharePoint Foundation
Category : Database
Event ID : f-_-
Level : Monitorable

Message :

A large block of literal text was sent to sql. This can result in blocking in sql and excessive memory use on the front end. Verify that no binary parameters are being passed as literals, and consider breaking up batches into smaller components. If this request is for a SharePoint list or list item, you may be able to resolve this by reducing the number of fields.

QL Profiler:

You may also like:


  1. http://social.msdn.microsoft.com/profile/msdn%20student/?ws=usercard-mini says :

    QL Profiler is your best bet.

    You can start a profiler trace and when you setup column filter for the trace. choose a filter for the NT Account with which your WFEs are running.

    That way you will see all the communication which is coming from WFE.

    Profiler is a heavy thing.. so make sure you turn off the trace when you are done.

    If you are looking to do a long term thingy.. then look at SQL Audit features.

    val it: unit=()

  2. http://social.msdn.microsoft.com/profile/hemantrhtk/?ws=usercard-mini says :

    We are evaluating some better and robust tools for this like https://newrelic.com

  3. Hi Hemant,

    In case you finalize approach/ tool for analysis, please share your analysis which tool is chosen and why? How tool has helped you a bit ?