Solved

Perfmon to analyse Disk Behaviour on window server 2008

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

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

792 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