Post reply

Benchmarking

  • October 15, 2010 at 7:20 am

    #225096

    Hi I would like to get the average number of transactions perday from our sql server installations, is there some built in functionality for this or does it require 3rd party software?

    Thanks so much

  • October 15, 2010 at 7:35 am

    #1237536

    Hi,

    Use PAL Tool: http://pal.codeplex.com/

    Best regards,
    Michał Marek

  • October 15, 2010 at 12:03 pm

    #1237765

    gianmh (10/15/2010)

    Hi I would like to get the average number of transactions perday from our sql server installations, is there some built in functionality for this or does it require 3rd party software?

    Thanks so much

    Just to get transactions/sec you can refer to the Performance Monitor and a counter of exactly that name. It'll give you what you need.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • October 19, 2010 at 9:58 am

    #1239154

    Thanks guys

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

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