Post reply

Database traffic reporting and analysing tool

  • March 11, 2005 at 7:38 am

    #88283

    Hi!

    Can any one suggest a tool or script which can show the traffic on a sql database on daily basis.

     

  • March 11, 2005 at 7:48 am

    #546615

    If you're only running the MS SQL Server on that box, then using PerfMon, and adding the requisite network counters will give you a view of approximately how much is hitting that server.

    If you want to go deeper, and find out exactly how much hits the DB server, then you need to head into the protocol analysis.

    This should be available to your Network admin (just ask how much traffic hits the SQL Server port on your box).

    By preference, I put firewalls in front of servers. This also gives an advantage of having all the protocol stats at my disposal. Linux with a nicely configured iptables works a treat!

  • March 11, 2005 at 11:44 am

    #546697

    I would run a Profiler Trace. You can configure it with a lot of events and filters to get all logon events, database batches, statements whatever is your business need.

    Yelena

    Regards,Yelena Varsha

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

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