1 / 15

SQL Server Management Perfected - Ensuring Database Performa

IT environments continue to grow in complexity. Organizations today are using multiple database platforms, embracing cloud technologies, and generating enormous volumes of data, and users have increasingly high expectations for availability and performance. These trends increase the pressure on DBAs to proactively find and address performance issues, even as budgets tighten. This paper outlines the resulting challenges for DBAs, and offers a solution to help. Get the free trial at http://dell.to/1iED8kK

SQLDBApros
Download Presentation

SQL Server Management Perfected - Ensuring Database Performa

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQLServerManagementPerfected EnsuringDatabase Performancein theFaceofToday’sITTrends January2014

  2. Intro Thelifeofadatabaseadministrator(DBA)isoftenstressful,asthey findthemselvesresponsibleto ensurepeak performanceand troubleshootissuesinincreasinglycomplexITenvironmentswithmore and moredata. Organizationstodayareusing multipledatabaseplatforms,embracingcloudtechnologiesand generatingenormousvolumesofdata. Thesemajortrendsincreasethe pressureonDBAsto proactivelyfindand addressperformanceissues, even asbudgetstighten. Based offofDellSoftware’slatestwhitepaper,“SQLServerManagementPerfected–Ensuring DatabasePerformanceintheFace ofToday’sITTrends,”(clicktodownload)thispresentationwill highlightthe broadITtrendsthat impactdatabaseenvironmentsand the resultingchallengesfor DBAs.Itwillalsoshowcasethe waysinwhichDell™SpotlightonSQLServer(clickforfreetrial)will help DBAsrest easy and deliverthe highservicelevelsorganizationsrequiretoday. Global Marketing

  3. ITTrendsDrivingDatabase Complexity Data CenterComplexity Datacentersarebecomingmore complexinseveraldifferentways. • Environmentsaremore heterogeneous – ArecentDellcustomersurvey revealedthe usageofmultiple platforms:Oracle,MySQLand SQL Servertonameafew. Mixofvirtualand physicalservers – ForcessomeDBAstotake onadual roleasvirtualizationadmins. • Global Marketing 3

  4. ITTrendsDrivingDatabaseComplexity CloudComputing–TheGreatDebate AccordingtoresearchreportedbyForbes,theworldwide cloud computing marketwillgrowat36percentcompoundannualgrowth ratethrough2016, reachingamarketsizeof$19.5Bby2016.Cloudcomputingwillleadtoamajor shiftinDBinfrastructureandrequiremajorupgrades.Thereare2typesof cloud databaseenvironments:privateandpublic. Based onthe decisionofthe organization,private and public cloudsimpact internaldatabases differentlyand DBAsmust monitorthe cloud environment. Global Marketing

  5. ITTrendsDrivingDatabaseComplexity CloudComputing–PrivateClouds -Aprivate cloudisaninternallyhosted databaseenvironment,whichprovides flexibilityinmanaginghardware resourcesassharedresourcepools. -Databasescan bespunuporshut downondemandand resourcescan be allocatedonthe fly. -Avirtualizationplatform(oreven multipleones)behindthe scenes powersthisprivate cloudinfrastructure. Global Marketing

  6. ITTrendsDrivingDatabase Complexity CloudComputing–PublicClouds -Apublic cloudisadatabasehosted outsideofthe company’snetwork using athird-partyprovider,i.e. AmazonWebServicesorMicrosoft Azure. -Inpublic cloudenvironments,the third party providesthe hardwareand infrastructure,whilethe ITcustomer “leases”the abilitytorundatabases. Global Marketing

  7. ITTrendsDrivingDatabaseComplexity ExplosionofData Datavolumes havebeen growingandwillcontinuetogrow, exponentially. Asthese volumes growlarger,challengesaround performanceandadministrationcontinuetogetmore complex. datasourceswillpopupandrequirespecialized knowledgeand ITDepartmentswilladdressdata growthinoneoftwo ways: Also,more expertise. • Addserversand databases.Asaresult, DBAswillbetaskedwithmonitoring, managing,reportingand maintainingalarge numberofservers. Consolidatedatabasesontosharedhardware.Managementand maintenancewillbeeasier,butimportanceofindividualserversrises significantly.Asaresult, DBAswillrequireamuchhigherlevelofvisibility. • Global Marketing 7

  8. ITTrendsDrivingDatabaseComplexity ExplosionofData –DBAsBeware Regardless ofaDBAsdecision toaddress theexplosion, tobemindfulofSQLServer“sprawl.” theymustremember DBAscannotbeeverywheretomakesure SQLstatementsarecodedproperly and that sharedSQLServerresourcesareconfiguredproperly.Here areafew thingstokeepinmind: Lookfortoolsthat can providevaluableinsightsintoactionand resolution. Lookfortoolsthat can take youtothe rootofthe performanceproblem. Proactivesolutionswillenableyoutoworksmarter,not harder. Global Marketing

  9. ITTrendsDrivingDatabaseComplexity ConsumerizationofIT Ifweweretoplaytheblamegame, allfingerspointtoApple. TheconsumerizationofITisfueledfromproductsthatdeliver cool,user-friendlyandinnovative devices.Thesedevicesfirst emergedintheconsumermarketandthenspread into corporateenvironments. Fromhere,twoadditionalissuesarise: • BringYourOwnDevice(BYOD).Employeesexpectthe flexibilitytoaccessand interactwith databases,includingSQLServer,throughtheirown devices.DBAsmustprovidesecureaccessvia non-companyissueddevices. ApplicationModernization.Today’sappsrequiregreaterconnectivitytoawide rangeofservices, eachofwhichcan affectavailabilityand performance.DBAswillneedtomonitorthe databaseand end-to-endbehaviorasappsbecomemorecritical. • Global Marketing 9

  10. How DoTheseTrendsAffect DBAs? Cloudcomputing,datagrowthandtheconsumerizationofITare threeof thebiggestdrivesofincreaseddatabasecomplexity. Notsurprisingly,thesetrendsalignwithsome DBAsidentify: • Inabilitytobeproactive • Lackofvisibility • Performancemonitoringissues ofthe mostcommon painpoints Global Marketing

  11. How DoTheseTrendsAffect DBAs? InabilitytobeProactive Mostdays,DBAsfeellikethey justcan’t get ahead.Theyworry aboutissues arisingmorning,noonand night –and sometimes,even overnight.Withoutan easilyaccessible,real-timeviewofthe environment,DBAsfinditextremely difficulttobeproactiveratherthan reactivewhenitcomestodiagnosing and addressingbothreal-timeand historicalperformanceissues. Global Marketing 11 Roomfortext

  12. How DoTheseTrendsAffect DBAs? LackofVisibility Visibilityintodatabaseactivityiseven morecritical asthe numberof transactionsgrows.Moreoftenthan not, thisnumbergrowsbecause: 1. Moreusersattemptingtoaccessa specificdatabasefrom various devices. Moremission-criticalapps running ontop ofdatabases. Moredata beinggenerated,stored and accessedfrom databases. 2. 3. Global Marketing 12

  13. How DoTheseTrendsAffect DBAs? PerformanceMonitoringIssues AlthoughSQLServerand other databasesincludenative monitoring toolstoprovidesomeinsight into databaseperformance,the viewing processiscumbersomeand time- consuming. Asaresult, DBAsmustuse multiple native tools,togglingfrom onesolution tothe next, whichslows downtheir effortstofindand addressissues. Global Marketing

  14. So,what’stheanswer? Nativedatabasemonitoringtools providebaselineactivityand performancemetricsthatprovideso muchrawdatait’sdifficultforDBAsto interpret,pinpointandaddresstheissue quickly. WithSpotlightonSQL ServerEnterprise,DBAscan guaranteedatabaseperformanceby: -Providing in-depthphysical,cloudand virtualSQL diagnostics -Pinpointingresourceshortagesand I/Obottlenecks -Releasingin-depthinformationonSQLServer clusters,replication,databasemirroringand log- shippingactivities Global Marketing

  15. The RightTools SpotlightonSQLServerEnterprise providesyouwithunmatchedSQL Server monitoring,diagnosisand optimizationofyourdatabase environmentstoensurepeak performancearoundthe clock. Don’t believeus?Downloadafreetrialhereandsee foryourself.And whileyou’reatit,whynotread throughthewhitepaper,“SQL Server ManagementPerfected”– youmightlearn somethingyou didn’t already know! Global Marketing

More Related