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 2005 Forums
 Transact-SQL (2005)
 how can i know if my disk is right?

Author  Topic 

inbs
Aged Yak Warrior

860 Posts
Posted - 2009-02-24 : 06:19:49
i write simple query of INSERT INTO

how can i see the performance of writing to the disk(i/o) and how can i know that is right?

sodeep
Master Smack Fu Yak Hacker

7174 Posts
Posted - 2009-02-24 : 09:05:32
Check the performance monitor:

AVG Disk writes/sec
- It should be less than 8 ms.
Go to Top of Page

inbs
Aged Yak Warrior

860 Posts
Posted - 2009-02-24 : 09:21:39
i get 0.250 what is mean?
you can send me where you find the number 8 ms?
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts
Posted - 2009-02-24 : 09:39:56
quote:
Originally posted by inbs

i get 0.250 what is mean?
you can send me where you find the number 8 ms?


That is Average no of bytes written to disk /sec.

I was saying about:
Avg disk sec/writes


Avg no of sec to write to disk.
Go to Top of Page

inbs
Aged Yak Warrior

860 Posts
Posted - 2009-02-24 : 09:47:30
yes this what i choose (AVG.Disk sec/write)
for physical disk

i make restart, and run again the query
after 1 minutes 0.100
after 2 minutes 0.022
after 3 minutes 0.025
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts
Posted - 2009-02-24 : 09:54:36
What are you using RAID 5 or RAID 10 or 1?
Go to Top of Page

inbs
Aged Yak Warrior

860 Posts
Posted - 2009-02-24 : 11:58:47
i do not know, how can i know that?
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts
Posted - 2009-02-24 : 12:20:23
quote:
Originally posted by inbs

i do not know, how can i know that?


Check with your Hardware guys?
Go to Top of Page

inbs
Aged Yak Warrior

860 Posts
Posted - 2009-02-25 : 01:59:09
RAID 5
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts
Posted - 2009-02-25 : 08:16:41
quote:
Originally posted by inbs

RAID 5


RAID 5 doesn't have good write performance as compared to RAID 10.
Go to Top of Page

inbs
Aged Yak Warrior

860 Posts
Posted - 2009-02-25 : 11:49:14
ok,so what can i do?can i change it?
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts
Posted - 2009-02-25 : 11:53:52
quote:
Originally posted by inbs

ok,so what can i do?can i change it?



No.

Post all results of Disk Counters in Performance Monitor during write operation?
Go to Top of Page

inbs
Aged Yak Warrior

860 Posts
Posted - 2009-02-25 : 14:40:00
what do you mean Disk Counters ?
i wrote before about AVG.Disk sec/write.
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site