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 |
|
schinni
Yak Posting Veteran
66 Posts |
 Posted - 2003-08-24 : 19:37:27
|
| hi,Is there a way good way to find out whether the database is read/write intensive on a shared server in sql2k/win2kThanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-25 : 12:19:02
|
| Performance Monitor could tell you this and also SQL Profiler although I still don't know what the values for Reads and Writes mean in SQL Profiler. The values are cumulative, but what do they mean?Tara |
 |
|
|
schinni
Yak Posting Veteran
66 Posts |
Posted - 2003-08-25 : 14:59:58
|
| Which performance counter is the best for this?Thanks, |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-25 : 15:09:18
|
| The disk counters will give you the information. % Utilization for both Reads and Writes. Check out physical and logical disk counters.Tara |
|
|
|
|
|
|
Database R/W?