Performance Performance Performance

Because Performance MattersPresented By:Raymond A. Rannala

www.soaringeagle.biz(941) 981-3913

Because Performance Matters

Soaring Eagle Consulting, Inc.

We recently helped one internet company reduce database response time from 7 seconds to a sub-second response.  This directly improved their web customer retention rate by 3% improving their monthly sales by $100,000.  www.clickinks.com

We helped a financial services company reduce the time it took to run a mission critical management report from 47 hours to 30 seconds. FSA Financial Services

Another client of ours was able to save the $250,000 that they were about to invest in new hardware. Our consultant identified database performance issues as the true source of unacceptable performance rather than the hardware constraints as they had guessed. www.Elluminate.com

So what does performance mean to businesses?

What does Performance mean to our clients?

Because Performance Matters

It means:

• More Profit• Lower Costs• Improved productivity• Competitive Advantage• Best use of their

technology investment

Because Performance Matters

So who is Soaring Eagle Consulting?

• A 12 year old Tampa Based Consulting company specializing in IT Performance - Database Performance in particular

• Owned by Jeff Garbus – A consultant, author and lecturer with more than 20 years of database performance experience

• Author of 17 books on database performance. (Google him)

• Newest book coming out June 2010• 20+ Consultants, Technical writers, Trainers,

Staffing and Sales Professionals• We have clients throughout the US, Canada and

Europe – referenceable!• Microsoft Partner• Database Experts!

Because Performance Matters

What Services do we offer?

• Consulting• Performance & Tuning• System Assessment• Emergency assistance (911db)• Database design and architecture for;

• SQL Server• Oracle• Sybase• DBII

• Application design and development• IT Strategy for growth or restructuring• Business Continuity• Retained Services

• Performance Software• Confio Performance Software• Precise APM Software• SafePeak

db

Because Performance Matters

What Services do we offer? (Continued)

• Managed Services• Oversight db™ - Remote Database

Administration• rpm™ - Remote Performance Management• Analytics on Demand – Advanced Business

Analytics

• Training• SQL Server, Oracle, Sybase• Performance & Tuning• Systems Administration• Microsoft Certified Trainers• Confio & Precise training

• Staffing• Contract- Permanent• Interim CIO

Because Performance Matters

Retained Consulting Services

Expert Assist is a program designed to schedule our top consultants for onsite visits on a periodic basis to address issues before they become critical. We can also schedule specific mentoring time to answer questions, offer best practices and share optimization techniques with your DBAs, and developers while onsite. Services include: • Assess current performance, systems administration, code, coding standards, preventive

maintenance, • Evaluate reliability, scalability, architecture, environment, security, and best practices• One-on-one or one-to-many mentoring sessions to answer questions, help code, teach new

techniques, enhance current techniques, review performance, act as a sounding board, offer guidance etc.

Retained Services

db Emergency Services

911 db is an optional offering of our retained services. The program is designed to provide emergency database performance and restoration service at critical times to assist Clients in restoring services in order to provide business continuity to the organization.

By using this service in conjunction with either Expert Assist or rpm, the hourly rate is discounted by 50%. If neither service is ordered, a retainer fee is required in order to have a consultant available on an on-call basis. There is a one hour minimum for each 911 db call. Soaring Eagle guarantees a 4 hour response but will make every effort to have a qualified consultant respond as close to immediately as possible. VPN or equivalent access is strongly recommended to ensure the fastest problem resolution time.

Because Performance Matters

Remote Database Management Service

Remote Database Administration Services

Provided and managed by the premier Database performance company in the industry

Small and midsized businesses have the exact same critical need for DBAs that larger organizations have. The major difference is that they don’t have the same resources and enterprise operations. Even for companies that already have in-house DBAs, outsourcing production database administration can free up DBAs to focus on strategic and mission critical activities.

• We provide Expert, Remote, 24 x 7 x 365 Monitoring Support for Oracle, SQL, Sybase and DB2 database technologies.

• Standard and Proactive monitoring support which not only deals with issues as they arise, but prevents operational surprises.

• A full time, dedicated, remote DBA working evening hours (10:00 PM ET –6:00 AM ET), Monday –Friday, not including weekends and normal US holidays. Coverage time may be shifted.

• 16 hours per month of remote, pre-emptive and proactive Principal DBA services

• Immediate Escalation -Principal DBA and Replication Phone Support

…All for about half the cost of a DBA

Because Performance Matters

Confio Ignite PerformanceConfio Ignite solves database performance problems. Built on twin foundations of Performance Intelligence and Wait-Time measurement, Ignite for SQL Server identifies the bottlenecks that cause applications to wait on SQL Server, reduces the cost of database operations, and drastically shortens the time to resolve database problems. For DBAs and developers, Ignite goes further than any tool to find the source of SQL Server bottlenecks.

Conventional tools measure server health; Ignite measures wait time. Conventional tools show just current statistics; Ignite uses Performance Intelligence to analyze historical trends and uncover the root cause of slow queries.

Ignite Highlights• Identify key offenders, those queries using excess SQL Server resources• Identify development changes causing SQL Server to slow down• Achieve faster problem resolution by finding true source of hidden

bottlenecks• Communicate across developers and DBAs to show why apps are slowing

down• Always on, with no load on production servers, to see all the problems• Wait Time Analysis exposes delays in end user service• Agentless Monitoring results in no system overhead

Ignite is the only tool that captures and graphically analyzes all the SQL Server wait type data, showing exactly which queries are waiting on critical resources and what can be done to fix them. The result is DBAs find SQL performance problems and fix them fast.

7

Because Performance Matters

Remote Performance Management rpm™ Service Overview.

The i3 application performance monitoring suite has amazing capabilities to monitor existing application issues, as well as to perform predictive analysis on monitored systems. Many IT organizations clearly see the benefit, of the i3 tool but simply do not have the time to set up alerts, perform predictive analysis, or to check i3 for issues unless somebody calls with an issue or complaint. While i3 is an ideal tool to help IT managers be proactive, it is more often than not used after the fact as a reactive measure to help resolve a serious problem.

Soaring Eagle Consulting’s rpm™ service enables your company to be proactive. By taking advantage of the features inherent in the i3 solution, we establish remote alerting, add ourselves to the alert lists, and follow up with you according to our established service agreement. This innovative service also delivers proactive tuning by our performance experts. They take a direct, hands on approach addressing negative trends and averting calamity.

This arrangement can range from simply alerting your team via email to an issue or potential issue, up through Soaring Eagle taking the reigns and directly enacting corrective measures. In essence, we can fix the problem or tell you how you can fix the issue. Your preferences and corporate policy will dictate the level of corrective action we will take.

Because Performance Matters

Service Deliverables“An Expert Set of Eyes”

Each service level includes up to 8 hours per month of direct interaction from one of our team of world-class DBAs or developers. Our response will depend upon the nature of the alert that is being identified. In addition, you have on-demand (prioritized) emergency performance & tuning advice. We offer 3 Service levels.

GOLDAll Silver-level services, plus proactive tuning on (at least) a weekly basis. Extended service coverage – 10 hours per business day. Up to 15 hours of performance recommendations per month. Up to 8 servers monitored.

SILVER

PLATINUM

We’re alerted when your system is performing sub-par, and act accordingly. You receive a monthly report of changes / recommendations. This report includes predictive analysis of systems monitored. Up to 4 Servers Monitored. Service monitored normal business hours. Up to 10 hours per month of performance recommendations

All Gold-level services and monitoring on a follow the sun basis. 7x24 monitoring. Up to 12 Servers monitored. 15 hours of performance recommendations per month. 20% discount on extra hours on any on site or off site service.

Because Performance Matters

TrainingOur trainers have real world experience, many have published books. All are professionals in the classroom. We are offering training in many disciplines. We also offer mentoring. Mentoring is designed to instruct your DBA‘s on your systems while in the course of doing a system review or performance and tuning engagement.

Soaring Eagle Provides:• Generic Database Courses• SQL Server Training

• Intro to MS SQL Server• SQL Systems Administration• Advanced SQL Admin.• Designing indexes for Performance• More…

• Sybase Training• Intro to Sybase• Practical Systems Admin.• Adaptive Server Performance & Tuning• Sybase 15 for Developers More…

• Oracle Training• Intro to Oracle for SQL Server and Sybase

Developers More…• Project Management

• PMP Certification, Six Sigma

Because Performance Matters

Some of our clients

“We are delighted to be judged by the company we keep!”

Because Performance Matters

Thank you!

How can we help you?

Ray Rannalaray@soaringeagle.biz

(941) 981-3913