SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Amount of data read / write in particular database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Sharjeel Kashif
Starting Member

Pakistan
3 Posts

Posted - 06/27/2014 :  01:13:19  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2062 Posts

Posted - 06/27/2014 :  03:16:44  Show Profile  Visit jackv's Homepage  Reply with Quote
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

Pakistan
3 Posts

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

Sharjeel Kashif
Starting Member

Pakistan
3 Posts

Posted - 07/01/2014 :  23:47:34  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2062 Posts

Posted - 07/02/2014 :  01:44:43  Show Profile  Visit jackv's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000