Performance Tuning your SAS Environment (Hints and Tips) Andrew - - PowerPoint PPT Presentation

performance tuning your sas environment
SMART_READER_LITE
LIVE PREVIEW

Performance Tuning your SAS Environment (Hints and Tips) Andrew - - PowerPoint PPT Presentation

Performance Tuning your SAS Environment (Hints and Tips) Andrew Gadsby SAS UK Customer Loyalty Team andrew.gadsby@sas.com 07880 253 430 Note: The views of the author many not reflect those of the company. Abstract This session focusses on


slide-1
SLIDE 1

Performance Tuning your SAS Environment

(Hints and Tips)

Andrew Gadsby SAS UK Customer Loyalty Team andrew.gadsby@sas.com 07880 253 430 Note: The views of the author many not reflect those of the company.

slide-2
SLIDE 2

Abstract

  • This session focusses on providing some guidelines
  • n how to approach performance tuning covering both
  • perating system and SAS options.
  • The information given and the hints and tips being

shared are based on the my experiences in helping identify and resolve performance issues within several SAS customers in the UK.

slide-3
SLIDE 3

Important

DISCLAIMER

  • These guidelines have been developed following visits to a number of UK customers where various

performance problems and have been reported and in many cases resolved following deeper

  • investigation. During these visits a number of common patterns have emerged that SAS

Administrators can, hopefully, exploit to improve and maintain performance in their environments.

  • This document is designed to help SAS Administrators tune their systems however, it is not a

definitive reference source, for that consult www.sas.com and the various SAS conference proceedings referenced below.

  • Finally, as a SAS Administrator you are responsible for your SAS environments and the topics

discussed should be carefully reviewed before being tested or used in a production environment as environments vary depending on specific configurations.

  • For assistance on tuning please in the first instance contact your normal SAS Support
  • representative. If you have additional hints and tips that you feel SAS users could benefit from then

please do let me know me on the email address below.

  • The views of the author many not reflect those of my employer.
slide-4
SLIDE 4

For Grid Sites See Also

http://api.ning.com/files/4O6eIqcn6-5EauYClb*X2Mn8YF6hlXUdHfdqciAoZOEqZgXZ*EnnLn-0eUanYHuxMJ4HKiUdtuLF5CzXofFUjxqHJ5- 2PMw4/BestPracticesforSASGridandLSFDeploymentsAndyGadsby.pdf

slide-5
SLIDE 5

Business Performance

  • 360 Benefit Check
  • Free service provided by SAS
  • 2 weeks engagement
  • Output/deliverables can be shared with senior management
  • Identifies
  • Benefits recognised
  • Missed business opportunities
  • Recommendations for continual improvement
  • SAS investing in your continual development

Jaap Piersma Business Advisory jaap.Piersma@sas.com 07918 708 938

slide-6
SLIDE 6

Getting Started

  • What is normal?
  • Things to collect?
  • Turn on FULLSTIMER and keep it on!
slide-7
SLIDE 7

Memory

  • MEMSIZE, SORTMEMSIZE
  • Buffers
  • BUFNO, BUFSIZE
  • Buffer Cache
  • Transparent_hugepages (LINUX only)
slide-8
SLIDE 8

PROC SQL

HTTP://WWW2.SAS.COM/PROCEEDINGS/SUGI30/101-30.PDF

  • Query Plans
  • proc sql _method _tree
  • proc sql buffersize=12345678
  • Default is 64,000 rows
slide-9
SLIDE 9

Views

  • Make extensive use of VBUFSIZE
  • Default is 32K
  • Experiment with bigger values
  • 1M – 200M
slide-10
SLIDE 10

Metadata

  • Needs cleaning – regularly!

http://support.sas.com/documentation/cdl/en/bisag/65422/HTML/default/viewer.htm#n1vl1pbgfeg71zn1cznorwizcg61.htm

  • Needs Monitoring and Tuning

http://support.sas.com/documentation/cdl/en/bisag/65422/HTML/default/viewer.htm#n0sch2ahexwy7xn1n67sf998iv92.htm

slide-11
SLIDE 11

Network

  • Network settings
  • Latency
  • Jumbo Frames
  • AIX : tcp_nodelayack (work in progress)
slide-12
SLIDE 12

Storage

  • SAS Recommends 100+ Mbytes/second/core
  • Split Data, SASwork, Util, Input/Output, etc.
  • FLASH storage
  • SASwork
slide-13
SLIDE 13

Questions

THANK YOU

Go and Have Fun Experimenting!