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 |
|
urdba
Starting Member
5 Posts |
 Posted - 2008-02-17 : 02:51:12
|
| If the columns I/O Read Bytes and I/O Write Bytes in Task Manager (Processes tab) are enabled (through View --> Select Columns), it shows that the sql server.exe process is doing vast amount of reads during the course of the day. For example, a SQL Server with only 2 user databases totaling 100 GB is showing almost 2 TeraByte reads under "I/O read bytes" within a 24 hours period. Is it normal? During this time there is not much work being done on the databases (i.e. dbs are under normal load). It's a SQL Server 2000 (sp4) install on Windows 2003 server.So question is, is this normal? Does this count include only physical reads or it includes both logical and physical reads?Can other forum readers share the same "I/O read bytes" numbers from their installs?Thanks! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-17 : 04:20:03
|
We can't tell. It depends on the nature of your application.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
urdba
Starting Member
5 Posts |
Posted - 2008-02-17 : 11:03:07
|
quote:
Originally posted by Peso
We can't tell. It depends on the nature of your application.
E 12°55'05.25"N 56°04'39.16"
Are they just physical reads from disk or it includes both physical and logical reads? I don't see app doing so many physical reads in a day. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-17 : 16:24:11
|
As said, it depends.How you rebuilt your indexes? Updated your statistics?Defragmented your tables?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-17 : 16:27:45
|
| How do you place db files on the server? |
|
|
|
|
|
|
Why does sql server process show v high I/O reads