Saturday, February 25, 2012

No. Of Records inserted into a table/database

How do I findout number of records inserted/sec into a table or database.What is the version of SQL Server?
"Balaji" <Balaji@.discussions.microsoft.com> wrote in message
news:406D4E62-A0D3-4CB9-9585-127A5A61D67B@.microsoft.com...
> How do I findout number of records inserted/sec into a table or database.|||I want to findout this information both in SQL Server 2000 and SQL Server 2005
"Uri Dimant" wrote:
> What is the version of SQL Server?
> "Balaji" <Balaji@.discussions.microsoft.com> wrote in message
> news:406D4E62-A0D3-4CB9-9585-127A5A61D67B@.microsoft.com...
> > How do I findout number of records inserted/sec into a table or database.
>
>|||If you want only INSERTED rows, you can create in both versions trigger on
table for INSERT and calculate them.
In SQL Server 2005 take a look at an OUTPUT clause
"Balaji" <Balaji@.discussions.microsoft.com> wrote in message
news:6FBE1B30-CC16-4BCB-9C6C-4E6D3852BC42@.microsoft.com...
>I want to findout this information both in SQL Server 2000 and SQL Server
>2005
> "Uri Dimant" wrote:
>> What is the version of SQL Server?
>> "Balaji" <Balaji@.discussions.microsoft.com> wrote in message
>> news:406D4E62-A0D3-4CB9-9585-127A5A61D67B@.microsoft.com...
>> > How do I findout number of records inserted/sec into a table or
>> > database.
>>|||In almost all cases, you have to clock it yourself.
Linchi
"Balaji" wrote:
> How do I findout number of records inserted/sec into a table or database.

No comments:

Post a Comment