Solved

Perfmon to analyse Disk Behaviour on window server 2008

Posted on 2013-06-25
3
1,036 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
Learn about cloud computing and its benefits for small business owners.
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

914 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

14 Experts available now in Live!

Get 1:1 Help Now