sas grid n.
Skip this Video
Loading SlideShow in 5 Seconds..
SAS Grid PowerPoint Presentation
Download Presentation
SAS Grid

Loading in 2 Seconds...

play fullscreen
1 / 15

SAS Grid - PowerPoint PPT Presentation

  • Uploaded on

SAS Grid. Department of Finance Canada. Agenda. SAS in the Department of Finance Before the implementation of SAS Grid Implementation of SAS Grid Effect on users Performance Conclusion. SAS at Department of Finance. SAS has been used for more than 25 years. Between 60 to 70 users.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'SAS Grid' - reese-lynch

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
sas grid

SAS Grid

Department of Finance


  • SAS in the Department of Finance
  • Before the implementation of SAS Grid
  • Implementation of SAS Grid
  • Effect on users
  • Performance
  • Conclusion
sas at department of finance
SAS at Department of Finance
  • SAS has been used for more than 25 years.
  • Between 60 to 70 users.
  • Mainly used with Tax Data. (Sales Tax, Personal Income Tax and Business Income Tax).
  • Tax Modeling, Data querying, SAS OLAP Cubes are the main functions used in SAS.
  • Analysis of Tax Measures in Federal Budget.
  • Around 10TB of data. With 10% growth every year.
before sas grid
Before SAS Grid
  • The Department had 3 Application servers. (1 per Business unit)
  • 1 Shared SAS Enterprise Business Intelligence architecture (including OLAP server and Web server).
  • 1 Metadata Server.
implementation of sas grid
Implementation of SAS Grid
  • SAS and Finance met to discuss our needs.
  • Finance filled out the SAS Sizing Documents
  • SAS made their architecture recommendations
  • SAS, Finance and Shared Services Canada discussed the SAS recommendations.
  • SSC bought the recommended hardware and configured it.
implementation of sas grid1
Implementation of SAS Grid
  • Finance and SAS installed and configured SAS Grid.
  • Finance migrated all their data.
  • Main users switched to SAS Grid.
  • Finance customized and made final adjustment on the new infrastructure.
  • All users are now on SAS Grid.
effect on users
Effect on Users
  • For now, Finance do not force users to connect to SAS Grid – Platform LSF.
  • For SAS Enterprise Guide Users:
    • Only one server (SASGrid), instead of 3 when a user had access to all data. Less confusing.
  • For Base SAS Users:
    • 1 new icon on their Toolbar

Local submitGrid SubmitRemote Submit

effects on users
Effects on Users
  • It’s easy to run job on the grid. Basically no impact on users.
  • However, to be able to take full advantage of the grid, some programming skills are necessary.
    • Running jobs in parallel.
    • Understanding SASWork.
effects on users work
Effects on Users - Work
  • One of the negative effect of SAS Grid, is the use of Work.
    • As each job on the grid starts its own session, then the Work is deleted after the job. So, all your “work” tables are then deleted. Thus, they aren’t displayed in your project.
  • Our new SAS infrastructure includes brand new physical servers, a new Cluster File System, new OS.
    • So the performance of all of our SAS Jobs are faster even if we do not take advantage of SAS Grid.
    • These new infrastructure seems to had improved the performance by around 25%.
  • As users are now using the best server available and not their dedicated one, this has a potential to improve the performance.
    • Sometime a dedicated server was quite busy and the 2 others were not.
    • This cannot be measured.
  • Running jobs in parallel has also improved the performance.
    • For example, a 45 min job on the older server now take 3 min when ran in parallel.
    • It is important to note that not all jobs can be parallelized.
  • Even if we aren’t using SAS Grid at its full capacity yet, it has helped the Department to improve the performance of our SAS jobs.
  • No decision has been made yet on if we should force SAS Grid or not.
  • Even if the impact on users is small, some training has to be given to fully utilized the system.