Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SanjeevBaranwal
Starting Member
14 Posts |
 Posted - 2008-12-12 : 01:59:47
|
| Please help me out for finding Amount of Data participated in a transaction. I am using a Dot Net application and SQL server 2005. It is a part of performance testing. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-12 : 02:01:20
|
| you mean rows affected? just use @@ROWCOUNT for that. |
 |
|
|
SanjeevBaranwal
Starting Member
14 Posts |
Posted - 2008-12-12 : 02:13:13
|
| No I dont mean record count. But what amount of data was used say in memory for any transaction through a Dot Net Appplication into SQL Server 2005. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-12 : 02:54:03
|
quote:
Originally posted by SanjeevBaranwal
No I dont mean record count. But what amount of data was used say in memory for any transaction through a Dot Net Appplication into SQL Server 2005.
you mean % of memory used? or cpu usage? |
|
|
|
SanjeevBaranwal
Starting Member
14 Posts |
Posted - 2008-12-12 : 04:53:50
|
| Yes you are correct. |
|
|
|
SanjeevBaranwal
Starting Member
14 Posts |
Posted - 2008-12-12 : 06:25:47
|
| I mean % of memory used. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-12 : 09:01:19
|
quote:
Originally posted by SanjeevBaranwal
I mean % of memory used.
http://support.microsoft.com/kb/907877 |
|
|
|
|
|
|
Data Size in a transaction