| Author |
Topic |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2009-04-13 : 01:27:53
|
| what is your recommendation ?i do not know what is my disk?(how can i know?)i use sql 2000,i have Intel Xeopn CPU 3 GHz,3.5GB of RAM.once in week my i/o get up to 30,000,000 so i need to resart of my server.thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-04-13 : 13:11:24
|
| what are your disk settings? What is result from Perf mon? Avg Disk queue length,% disk time and so on? |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-04-14 : 02:43:59
|
| where can i see that? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-14 : 02:53:07
|
Performance Monitor.Where do you get the value of 30 million from?I would start by profiling your server to see which operation yields the high IO.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-04-14 : 04:16:56
|
| i get 30 Milion from Task manager ,the i/o reads of process sqlserver.exe get to 30 M |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-04-14 : 04:33:43
|
| Avg Disk queue length 8.650 % processor Time 18.450 |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-14 : 04:36:06
|
30 million reads from a database server is common.If you ONLY have 30 million reads from the server during a week, the database is not very used.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-04-14 : 04:44:55
|
| but it is heavy to the server. the server is very slow when he get this i/o reads.so i need to make restart once a week.(i have sql 2000)what it measure i/o reads? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-04-14 : 10:23:13
|
quote:
Originally posted by inbs
but it is heavy to the server. the server is very slow when he get this i/o reads.so i need to make restart once a week.(i have sql 2000)what it measure i/o reads?
Then you need to get faster new disk so that reads and writes are separated in different disk. |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-04-16 : 03:01:44
|
| how he can read and write in seperate disk?can the same table be in seperate disks? |
|
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-04-16 : 05:18:49
|
quote:
Originally posted by inbs
Avg Disk queue length 8.650 % processor Time 18.450
u can check for Avg Disk Read queue length and Avg Disk write queue length to get a more detail info.[url]http://technet.microsoft.com/en-us/library/cc938959.aspx [/url]Regards,Ahmad Osama |
|
|
|
|
my i/o reads is very high