Solved

Perfmon to analyse Disk Behaviour on window server 2008

Posted on 2013-06-25
3
1,034 Views
Last Modified: 2013-07-08
Hello Experts,

We have one central SCCM Site server where we are facing an issue. The SMS_Inventory_Data_Loader of central SCCM Server unable to move the MIF Files to the database , It resulted in piling up the dataldr.box folder with huge *.MIF files.

I am not an SCCM Administrator , but when asked the administrator he said *.mif are inventory files which moved to database from dataldr.box location with the help of SMS_Inventory_Data_Loader .

As the data is not getting moved to the database , most of the inventories are not getting updated.

Hence we have opened the call with Microsoft regarding this issue and they have come up with an answer stating there are some disk issues in a server

Basically we are using one physical disk (G:) for SCCM and (F:) for SQL ,

The Technician analyzed the perfmon logs of physical disk and found the Disks needs to updated with latest drives and defragmentation has to performed.

Below is the analyses.

\PhysicalDisk(2 F:)\% Idle Time
        [Min: 0%, Max: 102.73%, Avg: 52.84%]
             - Disk is heavily utilized and may be a bottleneck.
             - Investigate Disk bytes/sec and individual process IO Data bytes/sec for high disk usage.

   \PhysicalDisk(2 F:)\Avg. Disk Queue Length
        [Min: 0, Max: 4,766.439, Avg: 17.676]
             - Generally up to 2 per spindle (Hard Disk Device) is acceptable.

   \PhysicalDisk(3 G:)\Split IO/Sec
        [Min: 0, Max: 5,114.549, Avg: 6.405]
             - Split IO operations make up 9.01% of Disk Transfers.
             - Avg should be extremely close to 0.000.
             - RAID may be too small/NTFS block too small.
             - Disk may have moderate to heavy fragmentation

Action Plan for disks
1.  Could you please involve vendor for the disk to check it? May be updating the drivers may help.
2.  There are lot of Split I/O for both F: disk and G: disk. I would recommend to defragment the disks


Also he was talking about Read Cache and write Cache , can some one tell me what are these all about.

Please let me know the above statement made by technician are vaild , since I have never taken or analysed perfmon logs.

Also  , Can someone let me know how to take the perfmon log and analyse it?

I want to be 100% before I carry out the "Action Plan for Disk" provided by the technician

Thanks,

-Prashant Girennavar.
0
Comment
Question by:Prashant Girennavar
  • 2
3 Comments
 
LVL 10

Expert Comment

by:Subhashish Laha
ID: 39274671
Yes, the Technician is correct. You should get your Physical HDDs checked by Vendor and defragment your partitions.

Split I/O should be zero or near to zero.

Split I/O: Shows the rate at which that I/O requests to the disk were split into multiple requests. A split I/O may result from requesting data in a size that is too large to fit into a single I/O or that the disk is fragmented on single-disk systems.

You can refer below articles to check and for explanations on disk perfmon counters.

http://msdn.microsoft.com/en-us/library/ms804035.aspx
http://technet.microsoft.com/en-us/library/cc938959.aspx
http://blogs.technet.com/b/cotw/archive/2009/03/18/analyzing-storage-performance.aspx

Read Cache and write Cache

http://sqlmag.com/sql-server/setting-readwrite-cache-different-types-workloads
0
 
LVL 10

Author Comment

by:Prashant Girennavar
ID: 39277188
Thanks for the explanation ,

Does this means if we defrag the both the disk , we should see some Spilt I/O sec avg value getting reduced?

Also he talks about some driver updates ,

Is he mentioning the BIOS/ RAID controller Drivers?

Thanks,

-Prashant Girennavar.
0
 
LVL 10

Accepted Solution

by:
Subhashish Laha earned 500 total points
ID: 39277533
Yes, after defrag - you should see some reduction in Spilt I/O.

Yes, you should update BIOS and RAID controller driver. Specially updating RAID controller driver is more important if available.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Join & Write a Comment

A quick step-by-step overview of installing and configuring Carbonite Server Backup.
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now