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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Amount of data read / write in particular database

Author  Topic 

Sharjeel Kashif
Starting Member

3 Posts

Posted - 2014-06-27 : 01:13:19
Dear All,
Hi,

I am using mssql server 2005 on windows server 2008 sp2.
I want to know how can I check what amount of data is written or read in a particular database in specific time.

Regards,

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-06-27 : 03:16:44
Do you want the actual data or do you require an amount such as MB?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

Sharjeel Kashif
Starting Member

3 Posts

Posted - 2014-06-27 : 05:37:20
Yes I want to know data amount such as KB or MB.
Go to Top of Page

Sharjeel Kashif
Starting Member

3 Posts

Posted - 2014-07-01 : 23:47:34
If there is any third party tool (some sort of analyser) that report us about amount of data write or read in particular database in specific time. Actually I want a graphical view about data written on daily basis.A tool that can also report previous data amount being written in databases.
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-07-02 : 01:44:43
Some ideas that could help are in this post - i.e define IOPs for the database server. http://www.sqlserver-dba.com/2011/08/define-iops-for-all-database-servers.html

Also, for the database file level IOPs use - http://www.sqlserver-dba.com/2011/01/sql-server-measure-io-transaction-rates-and-sysdm_io_virtual_file_stats.html


Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -