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 |
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... |
|
|
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 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.8 out!SQL Server MVP |
|
|
|
|
|