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 2000 Forums
 SQL Server Administration (2000)
 Is my database read or write intensive?

Author  Topic 

sql_er
Constraint Violating Yak Guru

267 Posts

Posted - 2010-08-06 : 18:08:49
Hi,

In MSSQL 2000 Server, how could one find out whether the db is more read intensive or write intensive?

Or, answer a question of: How many reads or writes occur on a daily basis?


Thank you!

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2010-08-18 : 07:02:40
run the profiler for your database, there are parameters for read and writes that you can use

--------------------
keeping it simple...
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2010-08-18 : 08:04:02
the only event you really need is Audit Logout Event.
It has Reads and Writes columns that count all reads and writes made by that connection.
then you just sum it up and you have your data.

___________________________________________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.8 out!

SQL Server MVP
Go to Top of Page
   

- Advertisement -