6 Replies Latest reply on Nov 21, 2011 6:51 PM by bibinbabu

    IBM DS4700 storage perfomance

    bibinbabu

      Could you please assist me regarding how to check the Storage performance.  We are using IBM DS4700 for SQL Database. LUN ID “Database” for SQL database and LUN ID “Logs” for SQL Logs. Our application Team complaining that SQL performance very slow  and I need to check the SAN LUN performance. When I open  SolarWinds Storage there is many option in the “Chart:” which option I need to select mainly and what is the definition of each components? Is there any recommenced IO performance? Kindly advice

       

      Database LUN

       

      Logs LUN

      Regards

      Bibin Babu

       

        • Re: IBM DS4700 storage perfomance
          bibinbabu

          Could you please assist me regarding how to check the Storage performance.  We are using IBM DS4700 for SQL Database. LUN ID "Database" for SQL database and LUN ID "Logs" for SQL Logs. Our application Team complaining that SQL performance very slow  and I need to check the SAN LUN performance. When I open  SolarWinds Storage there is many option in the "Chart:" which option I need to select mainly and what is the definition of each components? Is there any recommenced IO performance? Kindly advice

           

          Database LUN

           

          Logs LUN

          Regards

          Bibin Babu

          System Administrator

            • Re: IBM DS4700 storage perfomance
              bmrad

              Hi,

              If you have upgraded to STM 5.1, you can drill down on the Database or Logs LUN Target View and see what VM are driving load (if present) and see if other LUNs on the same Volume Group are loading up the disks.  It should tell you if you if the LUN is overloaded or if the Volume Group is overloaded.

              Brian

                • Re: IBM DS4700 storage perfomance
                  bibinbabu

                  [View:/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.11.31.97/DS4700-IBM.docx]

                   

                  Hi Team,

                  Here i have attached the Database and log LUN's  total I/Os screenshots. Please check and let me know whether  this LUN's perfomace is good or not.Do i need to check any other option for checking this SAN performance?Now i can see all the performance from storage profile but i don't know how to explain each option and what option we need to check mainly for SAN perfomance and what is the recommended performance like 5<less- good

                  5-10 < better

                  10-20> bad

                  please advice

                  regards

                  Bibin

                • Re: IBM DS4700 storage perfomance
                  DanielleH

                  To all following this discussion--would you please continue the conversation on how to check SAN perfomance thread?

                  Much appreciated!
                  DH

                • Re: IBM DS4700 storage perfomance
                  bibinbabu

                  [View:/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.11.31.97/Could-you-please-assist-me-regarding-how-to-check-the-Storage-performance.docx]

                    • Re: IBM DS4700 storage perfomance
                      PetrKnyttl

                      Hi!
                       
                       please click the 'Disk Perf' link above your chart - that will give you basic idea how disc is busy. However, if you need to find cause, I suggest to try APM - which is awesome not only for SQL. But, if you're using MS SQL or Oracle, please use following steps: click 'Settings' -> 'All Resources' -> 'Add' and choose 'Application MS-SQL' or 'Application Oracle'.

                      This will give you access to following performance data:
                      - CPU Usage
                      - Hit Ratio
                      - I/O Busy
                      - Total Server Memory MB