SQL Server Performance

Data Size in a Transaction

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by SanjeevBaranwal, Dec 24, 2008.

  1. SanjeevBaranwal New Member

    Hi,
    We have a requirement to find the amount of data that participated in a transaction in a Dot Net based application with SQL Server 2005 in Backened. Please suggest me how to achieve this.
    SanjeevBaranwal, Dec 24, 2008
    #2

  2. Mahmoud_H New Member

    Use DATALENGTH function to get length of column of any data type

    for example:

    use adventureWorks

    select DATALENGTH (DepartmentID )+ DATALENGTH( GroupName) + DATALENGTH( Name )+ DATALENGTH(ModifiedDate)
    from HumanResources.Department
    where DepartmentID =1

    result is: 80 byte(the lengt of row)

    Mahmoud_H, Dec 25, 2008
    #3

  3. FrankKalis Moderator

    Interesting requirement. Can you describe a little bit more what exactly makes up a transation for you?
    FrankKalis, Dec 28, 2008
    #4

  4. SanjeevBaranwal New Member

    Hi,
    Actually we are having a product development in a .Net Application and SQL server 2005. For measuring performance one of our requirement is to measure the amount of data that is getting loaded on screens of the application during any transaction or activity. Please help me on this.
    SanjeevBaranwal, Dec 28, 2008
    #5

  5. satya Moderator

    Welcome to the forums.
    Can you simply run the PROFILER to see what query is running at this time and take the data by referring to the data types that are used at this time, by simply calculating the record size
    satya, Jan 2, 2009
    #6

Share This Page